setup

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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

> 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 ?

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 ?

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
http://www.outlookcode.com/jumpstart.aspx


"Lars Roland" <roland@diku.dk> wrote in message
news:Pine.LNX.4.58.0408101413270.12067@brok.diku.dk...
>
> > 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 ?
>
> 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 ?
>
> 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

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






*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

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.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"PeterQ" <anoniempje@devdex.com> wrote in message
news:%23rPXr43fEHA.3916@TK2MSFTNGP11.phx.gbl...
> 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
>
>
>
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!