How does one convert a VBA Module into a DLL
(I'm thinking this is an alternative to compiling into EXE file). Some of my VBA modules are quite complex and I would like to protect them with something other than a VBA Project password.
ChasAA
VBA Module to DLL
Hot Topic
- NUMBER GENERATOR HELP NEEDED
- The specified module could not be found??
- How do connect an Excel file from Remote Server
- Setting a global variable and referring to it from a private sub routine?
- List Box Search
- Error When Using Range(Cells()) to Paste in Excel
- Making process modal
- Password protecting to a command button in Excel?
- Macro stops running after a certain time, excel limitation???
- Sql SELECT query from VBA in Access
Microsoft ISV
- Visual Basic for Excel
- converting text to Hours Minutes and Seconds
- Creating Logon in MS Access
- Multiple series addition problem
- Limit Macro to current workbook
- Service won't use default printer
- Intersect method
- Bundling OA2007 Express with our product
- Unsuccessfully trying to open Power Point Viewer
- Questions on Excel.VBA -> Range.End()
VBA Module to DLL
deltaspecops99
Thanks Jon,
I'll have a look
ChasAA
Bolugbe
The book "Professional Excel Development" by Bullen, Bovey, and Green covers this. Although the book concentrates on Excel, the VBA-DLL thing should be valid for any application that hosts VBA.
There's a link to the book on my web site:
http://peltiertech.com/Excel/xlbooks.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______