locked
VBA Module to DLL RRS feed

  • Question

  • 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

    Thursday, July 27, 2006 4:56 PM

Answers

  • 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
    _______

    Thursday, July 27, 2006 6:23 PM

All replies

  • 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
    _______

    Thursday, July 27, 2006 6:23 PM
  • Thanks Jon,

    I'll have a look

    ChasAA

    Thursday, July 27, 2006 6:47 PM