Create VBA Executable 1

[mveera]

Hi,

I have a VBA application in Microsoft Excel. I would like to know how i can create a standalone executable from the excel application.

Thanks
Veera

 

[SkipVought]

Hi mveera,

You have a VBA Module. It can ONLY be run from within that application (Word, Excel, Access etc)

You could export the module, which will be a .bas file and then import the module into VB to create an .exe. But you have to have stand alone VB.

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[mveera]

Thank You very much.

The users will not be having VB installed on their systems. So i will just give them the forms with passwords set to prevent them from viewing the Codes and other sheets.

Thanks
Veera

 

[SkipVought]

Users do NOT need VB, but YOU or SOMEONE does to create the .exe

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com