making VBA an .exe

[jaird]

i was wondering if there is any way to take the modules from ACCESS written in VBA and make it into an exe file. Is there a compiler or something like in c++? i have ACCESS 2000.
Thanks

 

[dsi]

I don't think that you can make an .exe using VBA. You could port the program into VB, with some modification. I am not sure about Access, but with Word and Excel you can compile the VBA code into an add-in. NOTE: Make sure that you save a copy of your application because, last time I checked, it overwrites your VBA files during the compile.

 

[jaird]

i will try that, thanks

 

[jackha18]

how can i compile a vba module to an add-in? is there any way to make this add-in automatically to add toolbar button when it's being added to word? thanks

 

[PaulTEG]

In answer to the Access query, you can crreate a compiled Access Distributable (.mde)

Tools --> Database Utilities --> Make MDE file

In Access 2000 Developer edition I believe it is possible to make a fully ditributable Access Database, without leaving access to modules etc

try

http://www.microsoft.com/AccessDev/ProdInfo/ac97enh.HTM

HTH
;P