Trasnfer a Macro

[Greg Karson]

How can I copy a Macro from one file to another?

thank you,
Greg

 

[David Heaton]

How can I copy a Macro from one file to another?

thank you,
Greg

Greg,


When you create a macro it stores it in a User Module.

Go into the VBA editor (ALT+F11)
Right click on the module in question and select export.
you can then save the module where you want and import into a new file
using the VBA editor again

regards

David