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: 493
  • 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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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