Deploying macros
 

I've written some simple macros that I want to deploy to about 50 computers.
Rather than invest in Visual Studio Processional, I want to just copy the
Vbaprojectm.otm file to each user -- none of our users have written any
macros.

I can automate the copy easy enough, but is there a way to install the
certificate automatically? The project was signed with a certificate created
by selfcert. When I deploy the macros by copying VbaProject.otm, I get a
macro security warning. I can then manually install the certificate, but it
takes a lot of mouse clicks -- Details, View Certificate, Install
Certificate, then click through the Wizard. When the certificate is
installed I can then check the Always Trust This Publisher checkbox.

Is there a way to automate this, maybe a command line that could be added to
the bat file that copies theVbaProject.otm file?

Thanks,

--Doug

Deploying macros
 

AFAIK you have to do it manually. It's one of the disadvantages of
distributing VBA code.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"Doug" dougATloweNOSPAMwriterDOTyou-know-what wrote in message
. ..
I've written some simple macros that I want to deploy to about 50
computers. Rather than invest in Visual Studio Processional, I want to
just copy the Vbaprojectm.otm file to each user -- none of our users have
written any macros.

I can automate the copy easy enough, but is there a way to install the
certificate automatically? The project was signed with a certificate
created by selfcert. When I deploy the macros by copying VbaProject.otm, I
get a macro security warning. I can then manually install the certificate,
but it takes a lot of mouse clicks -- Details, View Certificate, Install
Certificate, then click through the Wizard. When the certificate is
installed I can then check the Always Trust This Publisher checkbox.

Is there a way to automate this, maybe a command line that could be added
to the bat file that copies theVbaProject.otm file?

Thanks,

--Doug