MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Common Module

Posted by Anurag Agarwal on September 27, 1999 9:17 PM

I have developed a set of procedures, functions as .bas file which I would like to share across a number of workbooks. How can this be acheived ?

Thanks in Advance


Posted by Ivan Moala on September 28, 1999 8:50 PM

There are a number of ways to do this.
You can create a workbook called "personal.xls"
and import the .bas file to this module then
save it your excel start dir
C:\Program Files\Microsoft Office\Office\XLSTART
This will make the macros available to your excel
applications when starting up excel.
or you can save the .bas module to a workbook and
save it to a dir you setup for this perpose eg name
it say "MyFunctionAccess".
When you want another workbook to access these
functions then in the VBA editor select <Tools>
<referemces> and browse for the file in the
"MyFunctionAccess" Dir. Select this and it becomes
avail. for your current workbook.



PS otherwise just import it to the file you want.

Posted by Ivan Moala on September 29, 1999 1:04 AM

The above has been amended as I had text enclosed
in scripting brackets that never appeared.