Writing COM Addin with VBA

[Guest]

Hi All,

I have wrote some code with VBA. In my project, I got 2 forms, 1 Module, and 3 Object Class Modules. The code work fine on my own machine. However, what I want to do is to deploy the code to anyone who want it.

I search around google and seems writing a COM addin should do this. However, most of the example for writing COM addin for outlook is in VB6. I would like to know if this is possible to do it in VBA?(So I dont need to move my code from VBA to VB6)

And could anyone provide me some example on it?

Thank a lot

Regards,

Seve

 

[Lars Roland]

When you say VBA I assume that you have written an macro. It is a lot
easier to deploy an VB6 COM than doing it with a macro (some people deploy
VB code in Outlook, using files such as outcmd.dat, but this is not
recomended and is allmost sure to cause you problems in the future).

check out the itemsCB vb6 COM addin example from microeye it is very easy
to understand and extend.

http://www.microeye.com/resources/itemsCB.htm



Regards.

Lars Roland

 

[Sue Mosher [MVP-Outlook]]

To write a COM add-in with VBA, you would need Office 2000 or XP Developer
Edition.

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

Hi All,

I have wrote some code with VBA. In my project, I got 2 forms, 1 Module,

and 3 Object Class Modules. The code work fine on my own machine. However,
what I want to do is to deploy the code to anyone who want it.

I search around google and seems writing a COM addin should do this.

However, most of the example for writing COM addin for outlook is in VB6. I
would like to know if this is possible to do it in VBA?(So I dont need to
move my code from VBA to VB6)