Custom installation for vba macros

[A Schwabe]

I'm fairly new to this vba programming thing so please bear with me...

I've written a few vba routines for our office to generate faxes, letters,
mailing labels, etc. from Outlook contacts. I created a toolbar and buttons
to add them to my Outlook and now I want to share them with the rest of the
employees. Is there a way to create these files as some type of add-in or
something similar that I can distribute to others or do I have to go to each
individual machine and load the files and create the custom toolbar.

Any advice would be greatly appreciated.

Arnold S.

 

[Sue Mosher [MVP-Outlook]]

Not really. A COM add-in installed on each user's machine through a normal
setup program would be the best solution, but takes more programming work.
See http://www.outlookcode.com/d/comaddins.htm

 

[Michael Bauer]

Hi Arnold,

you could distribute the *.otm file, but that will override any existing
macros on the other machines.

The best way would be to build an Add-In, e.g. by VB. Such an Add-In you
can distribute by a setup.

 

[A Schwabe]

Thanks for the quick replies. I was afraid it wouldn't be that easy. Maybe I
can convince the office to buy a full VB program or Office Developer???

Arnold S.