Convert OL VBA - Code into com add-in

[Joerg Meier]

Hi,

i am Using MS Outlook 2003.

I wrote an Outlook-VBA to move sent emails from the personal sent box to the
group-account sent box, if sent on behalf of it.
Now I want that everybody in our department uses this vba.

But I cannot go to every staff, open outlook, copy the code and disable
makro-security. Too much staff.

So somebody in the MS Outlook Newsgroup told me, that I have to do this
with a COM ADD-IN.

Shit. I really know nothing about COM ADD-INs.

Is there a possibility to simply convert the VBA-Code into a COM ADD-IN?
How do I register the COM ADD-IN for every user?

Thx

Joerg

 

[Michael Bauer]

Am Sun, 21 May 2006 15:04:03 +0200 schrieb Joerg Meier:

Joerg, please see my answer in de.outlook.

 

[dave.wayne]

If you could post the answer here as well, I am sure lots of people
would benifit from your knowledge

 

[Michael Bauer]

Am 30 May 2006 17:59:19 -0700 schrieb (e-mail address removed):

In the German group he told that he wants a VBA project to be used by every
member of a specific user group.

Using a COM Add-In for that scenario was only one part of my answer. The
other suggestions were to use Custom Forms, or to copy that VBA project into
each user profile.

Then he asked for a tool that converts the VBA project into a COM Add-In
because he don´t want to learn VB.

This was my answer then:

You can do the migration from VBA to VB almost 1:1. All you need is Visual
Basic 6 or an Office Developer Edition for being able to create ActiveX
DLLs. So the "tool" you´re asking for is a proper developer environment.