Export/Inport Macros

[Tail Wind]

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

 

[Jim Cone]

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

 

[FSt1]

hi
yes. a workbook has to be open to run it's macro. that is why some people
put macros in their personal workbook in the xl start folder so that the
macros will be available for all files. so in your case, i think you would
have to export.
and you're on the right track about import and export.
in the vb editor, expand the project and right click the macro, click export.
it will export as a bas file. I use to have a special folder for all of the
macros i had exported. to import, in the vb editor, right click the project
you want the macro in. click import. you may need to decide if it's a sheet
macro, workbook macro or just in a standard module.
good luck
Regards
FSt1