D David Heaton Jun 23, 2009 #2 How can I copy a Macro from one file to another? thank you, Greg Click to expand... 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
How can I copy a Macro from one file to another? thank you, Greg Click to expand... 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