Move a macro

Question

How do you macros from one workbook to another?

Answer 1

Well I used the "drag and drop" suggestion from Chip. It copied the module. Can I now go back to the source file and delete the module there?

Thanks guys,

Robert

Delete if you choose.   No harm if you don't want macros in original workbook.

Gord

Answer 2

Well I used the "drag and drop" suggestion from Chip. It copied the module. Can I now go back to the source file and delete the module there?

Thanks guys,

Robert

Answer 3

 How do you macros from one workbook to another?

While in VB Editor of workbook one File>Export each module as a *.bas file.

Open new workbook, open VBE and Import the *.bas file or files.

Save new workbook.

Gord

Answer 4

Open the VBA editor and then open the Project Window (CTRL R) if it is not already visible, typically on the left side of the screen. Open the "modules" folder of the source workbook and find the module containing the procedure in question. Then, in the destination project, insert a new module (Edit menu, Insert, Module) and then copy and paste the procedure from the source project to the destination project. If you want to move the entire module and all the procedures it contains, you can drag and drop the module from the source project to the destination project. The is no (practical) limit on the number of procedures contained within a single module, so you can copy multiple procedures from the source project to the same module in the destination project.