• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 505
  • Last Modified:

Make VBA Script Distributable as COM

Hi,

I've put together a VBA script inside Microsoft Outlook's Visual Basic Editor.
It has a single form with code behind the form.

How do I take this Outlook VBA project and create a distributable file, I've heard people call it a COM object?

Thanks.
0
gamm
Asked:
gamm
1 Solution
 
WikkardCommented:
Way to reuse your code to make a COM object would be to compile it with Visual Basic 6. You will need to make a few minor code changes probably.

This is the only way that I know of, AFAIK you can't compile a VBA project to an active x dll.
0
 
TaconvinoCommented:
Check this out:

"Managing and Distributing Outlook VBA Projects"
http://support.microsoft.com/kb/229911/en-us

"How to create a COM add-in for Outlook 2002"
http://support.microsoft.com/kb/291163/EN-US/

Hope this helps!
TCV
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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