Automatically installing VBA Code

[sportiva79]

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]

a discussion of this can be found at http://www.outlookcode.com/article.aspx?id=28 . hope it helps!

[sportiva79]

That's exactly what i needed, thank you very much