Programmatically Create/Install VBA Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Back
Top