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
- Size Form to fit user resolution
- Using ApplyCustomType with variable numbers and types of series
- Sort rows within a range
- Digital Certificate Error
- In a Replication Config (Transaction) >> HEADS UP >> "ANSI_NULLS set incorrectly" error
- Changing Character Length Setting for a Memo
- "How to" Programatically hide or display pivot items of pivot field
- opc
- Method 'SnapshotPrint' of object 'ISnapshotViewer' failed.
- DLookup help?
Microsoft ISV
- Indeterminate behavior from DoCmd.TransferSpreadsheet in Access 2003?
- Refer to another module tag
- Assign an array to .values and .Xvalues in an excel chart
- Using Inet to download an FTP File
- How To Open A File On Another Computer On A Home Network
- Open PDF file
- Help with highlighting employees nominating each other for awards...
- Placing data in matrix
- Can't open regedit
- Sort rows within a range
VBA Module to DLL
TiKu
Thanks Jon,
I'll have a look
ChasAA
Markw2004
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
_______