Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 881
  • Last Modified:

Create a COM Add-In for Outlook from an Outlook VBA Project

I wrote some VBA code in MS Outlook, and I'd like to take the code and create COM add-in so that the deployment of the code is easier and more secure.  I've never created a COM add-in before and I'm having a lot of difficulties with coding this type of project.  I'm using Visual Basic 6 as the development environment.  Do you have any tips for taking code from an Outlook VBA Project and using that code to create a COM add-in?
0
Scotto13
Asked:
Scotto13
1 Solution
 
will_scarlet7Commented:
Have you read this already?

http://support.microsoft.com/?kbid=291163
0
 
Scotto13Author Commented:
will_scarlet7,

Yes, I've read the article that you posted.  I've also been reading chapters in several Outlook Programming books, and I cannot seem to take the information provided and apply it to the VBA code that I've already written.  I'm reading "Building Applications with MS Outlook version 2002" and it says that you can basically copy and paste your VBA Code into a New Add-in Project using Office XP Developer.  I do not have XP developer.  I'm trying to create the COM-Addin using Visual Basic 6, and I'm looking for the copy and paste solution!  Does it exist?
0
 
MikeJordanCommented:
Hi! You might find the below link helpful. It doesn't directly cover Outlook, but gives examples on creating an add-in with other Office programs, the downloadable executable: odc_comaddinvb6.exe is also quite similar to the "COM ADD-IN.VBP" template available with Office Developer.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnoxpta/html/odc_comaddinvb6.asp

I think that you should pretty much be able to paste in your functionality code from VBA, the main thing would be that you'll need to handle the registering/unregistering of your object and also be able to respond to the COM events described in this article as well as the one listed above.

Hope that's a help in some way! -- Mike
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now