Forum Discussion
Copy Macros from a file to another file
Hello I've tried to copy Macros from an Excel File into another Excel File, both opened, using VBA, but without success; on the Explorer, I can see the sheets of each File, by their name, but the Mo...
You can double-click a module in the Project Explorer pane of the Visual Basic Editor to inspect its contents. One module can contain multiple macros and functions.
You can copy a module from one open workbook to another by dragging and dropping it in the Project Explorer pane.
Hi Hans
great help.
It works fine;
had to rework a couple of things, like redefine location of Macros on new file, search right modules to transfer, but it definitely saved me a lot more of work.
Thank you very much
Regards