VBA Vs COM Add In

L

Lp12

Hi all,
I have a code (with custom form) that i want to deploy in my org.
I examine a bit and find out that i need to write a COM add-in for that task.
I'm a newbie in VB so i wanted to know:
A) can i use the VBA code for the routines i wroteor i need to exchange it
with VB one?
b) What are the basic stepes in creating a add in in VB6?
Thanks a lot in advance
 
K

Ken Slovak - [MVP - Outlook]

VBA code should be almost 100% compatible with VB 6 code. The main
differences are that VBA gives you the Application object and in VB you'd
need to instantiate one (or more precisely use the trusted Application
object passed in the On_Connection event). Any forms you created in VBA
would use VBA UserForms, in VB they'd use VB forms.

I recommend that you download the ItemsCB Outlook COM addin template as the
skeleton for your addin (www.microeye.com, on the Resources page), it
provides a framework for you plus workarounds
for many common COM addin problems. You also should review the information
at http://www.outlookcode.com/d/comaddins.htm.
 
Top