PDA

View Full Version : Automatically installing VBA Code



sportiva79
05-21-2008, 09:01 AM
Hi all,

We have set up the staff in my office with a shared primary account, and a personal secondary account. This obviously creates some problems in how Outlook handles some of its core functions. For this i have written a few VBA routines to mitigate these issues which seem to all be working well.

To put these on people's machines currently i have to open their visual basic editor and then import each of the class files in manually. This is obviously not ideal, especially if i were to move on, as it is cumbersome and prone to mistakes.

Is there some way i can write an installer that when run will copy all the code into the relevant directories of the user's machine? If so, if anyone could give some direction on this, what to code it in, and where the directory structure is, i would very much appreciate it.

Thanks again,

L

tpoynton
05-22-2008, 08:34 AM
a discussion of this can be found at http://www.outlookcode.com/article.aspx?id=28 . hope it helps!

sportiva79
05-23-2008, 01:45 AM
That's exactly what i needed, thank you very much