convert excel macro into VBA program 1

[celestinogalan]

Does anybody know how to convert an excel macro (with vb code)into a VBA program (*.exe)

thanks

 

[Pcfred]

VBA is application dependent...you would have to have Visual Basic to convert to an executable.

 

[Nikita6003]

Have you looked into the possibility of creating an .xla file - an Excel addin? This allows you to protect the code, and, using the add-in manager, add a reference to the xla to any&all instances of XL

HTH

Cheers
Nikki

 

[celestinogalan]

Thanks
¿Could you, Nikita6003, tell me how to do this?

 

[Nikita6003]

Hi - sorry I posted this fairly late, but this pdf explains all about addins.

http://gioconda.di.uminho.pt/UMLe/archive/documents/vbaddins.pdf

If you still need a hand let us know ;-)

Cheers
Nikki