Question about deploying a macro

  • Thread starter Thread starter noone
  • Start date Start date
N

noone

Hello all,
I recently wrote a macro on my local machine in Outlook VBA. It is saved as
VbaProject.OTM.
I am ready to deploy this to about 60 users. The macro has been
"self-certed" by myself.

The macro also makes a reference to the freeware version of the Redemption
DLL. We also have created
a button on the toolbar for the macro.

1. Is there an easy way to "deploy" this macro to all of our users ?
2. Is there a way so that all the users use the same copy of the code ? In
case we need to make changes,
we don't need to re-deploy all over ?

Thanks.
 
The best way is really to write the code as a COM addin. Distributing
the entire VBAProject.OTM file will overwrite any macros the users may
already have and there's no way to share the project or easily
distribute it. In addition, for Redemption you would need to download
it and register it on each machine. The free version is not
distributable legally.

See http://www.slipstick.com/dev/vb.htm for a discussion about
distributing code.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Lead Author, Professional Outlook 2000 Programming, Wrox Press
Lead Author, Beginning VB 6 Application Development, Wrox Press
Attachment Options
http://www.slovaktech.com/attachmentoptions.htm
Extended Reminders
http://www.slovaktech.com/extendedreminders.htm
 
Back
Top