Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Outlook VBA: Is it possible to reference code in external files?

Status
Not open for further replies.

outofmemoryerror

Programmer
Nov 12, 2005
3
GB
I support a custom tool developed for Outlook. It's all code written into the vbaproject.otm file, which is then distributed to each user.

The problem with this is that when i need to make changes to the tool i have to redistribute new versions of the vbaproject.otm file to each user. (This has been scripted and automated, but it's still somewhat of a pain in the ass for the end user.)

I would like to know if it's possible to reference external code files from vbaproject.otm. What i'm imagining is keeping very little code in the vbaproject.otm file, and getting it to reference external files containing code in a shared location. These could then be updated at will without having to redistribute vbaproject to each user.

Is this possible with VBA for Outlook?

Many Thanks in advance for any assistance.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top