Programmatically Create/Install VBA Macro

[Guest]

I am in need of installing/creating a marco on several computers, and rather
than have to create each one individually, I'd like to create an installer
program (somehow). Is this even possible, and if so how?

Thanks for you time.

 

[Ken Slovak - [MVP - Outlook]]

Not possible. You would have to copy the entire VBAProject.OTM file over and
wipe out any existing macros or just add that code to each existing VBA
project.

VBA macros are not designed for deployment. For deployment a COM addin
should be used.

 

[Guest]

You're better off migrating your code to a COM Add-In, which can be packaged
in a Windows Installer Package and is the supported solution for distributing
Outlook applications.

See also:

Distributing Microsoft Outlook VBA Code:
http://www.outlookcode.com/d/distributevba.htm

 

[Guest]

Thanks for the information Eric. It it very useful.