Custom installation for vba macros

  • Thread starter Thread starter A Schwabe
  • Start date Start date
A

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