macro include directive

[bkelly]

I want to put a bunch of constants in a separate file so that can be referenced by several macro modules. I also have some support macros that are used by many other macros. What is the command to include a file as in the C language statement:
#include file.bas

Thank you

 

[xenou]

Offhand I'm not sure - one idea might be to put an open event handler in the workbook with the "code repository". See if you can set it to read-only at that point. In my experience, I did this once and my users (about 3 or 4) never once asked me about it or complained. If I were to have 20 users I'd probably feel a certain professional pride about solving that! But it seems that in general you could expect users to click okay and get on with bigger things.

If you want to get more sophisticated you can compile your helper code into a dll or xll with either VB6 (if you have it) or Visual Studio 2005/2008/2010.