1. Set up a separate folder in Windows explorer to keep your modules.
Right-click on a module and select Export File.
To import a module, right-click the project name and select Import File.
-or-
2. The quickest way to copy a module is to simply click and drag it to
the other project. A copy is automatically created.
-or-
3. You can also Insert a new module in your project and then copy the
code from another module and paste it in the new module.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)
"Tail Wind"
wrote in message
Hi,
I have two workbooks. One contains nearly all the macros being used by both
workbooks. I need to share these workbooks with other users and wish to make
each workbook's macros work whether or not the other workbook is open or not.
Do I need to export the macros from one workbook to the other?
Assuming the answer is YES, can I right click on the origin workbook
"Modules" heading and "Export" to the default filenames, then in the
destination workbook in Modules, right click and use "Inport"?
Is there a trap I need to know about?
Still learning as I go!
Many thanks in advance,
Brian