setup

  • Thread starter Thread starter PeterQ
  • Start date Start date
P

PeterQ

Hi Team !

I have this question: I have written some VBA macro's. And now the
system administrator wants to know what actions are to be undertaken to
deploy this new functionality to some thirty/fourty users.
How can I automate the process -after installing the VBAProject.OTM file
in the proper directory- to install my digital signature in the Outlook
client as well as the extra components I have added to my project (such
as MS TreeView, Slider, StatusBar and Calendar ? Will the system
administrator have to install this all manually for each Outlook client
that is going to use my VBA macro's ?

thnx in advance for replying.
greetings,

PeterQ
 
Hi Team !

I have this question: I have written some VBA macro's. And now the
system administrator wants to know what actions are to be undertaken to
deploy this new functionality to some thirty/fourty users.
How can I automate the process -after installing the VBAProject.OTM file
in the proper directory- to install my digital signature in the Outlook
client as well as the extra components I have added to my project (such
as MS TreeView, Slider, StatusBar and Calendar ?
Click to expand...

This is much easier using an COM addin, there is almost no easy way of
deploying a macro unless it is within your own organisation.
Will the system administrator have to install this all manually for each
Outlook client
that is going to use my VBA macro's ?
Click to expand...

He could get the job done fast, using a MSI tool, if all of the
clients are using the exact same version of outlook.

We have a few macros that are send to all our clients this way, but is not
easy to maintain (eg. sometimes things break if the clients use
windows/office update).


Regards.

Lars Roland
 
The VBAProject.otm file can also become damaged, causing the user to lose
all macros. COM add-ins are definitely the right technology for enterprise
code deployment, not VBA modules.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Hello Teammembers !

Thank you very much for replying.
But: can't I prevent the vbaproject.otm from being corrupted by marking
it as a read-only file ?

greetings
Peter
 
Feel free to try it, but I suspect that may cause it not to work at all.
It's also possible to password protect it. A COM add-in is still the right
method for creating code for everyone in a company to use.
 
Back
Top