Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2004-08-23
3
Medium Priority
?
875 Views
Last Modified: 2012-06-21
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
Comment
Question by:Scotto13
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 15

Expert Comment

by:will_scarlet7
ID: 11874399
Have you read this already?

http://support.microsoft.com/?kbid=291163
0
 

Author Comment

by:Scotto13
ID: 11875393
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
 

Accepted Solution

by:
MikeJordan earned 1500 total points
ID: 11881417
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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Mailbox Overload?
This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question