Move All Macros To New Workbook

[Nanogirl21]

Is there an (easy) way to move ALL macros to a new workbook? I need to move around 100 macro's. The only way I know how to do this is to:

(1) Copy and paste everything into new modules.
(2) Export each modules 1 by 1 and then import into new workbook 1 by 1.
(3) Drag and drop each macro into the new workbook 1 by 1.

Is there any add-in that allows movement of multiple modules at once? Maybe even an export all modules and import all modules option?

 

[jmacleary]

You could first copy them all into a single module, then you've only got to export that 1 and import it.

 

[yky]

Are all macros in one workbook? And you want to move all of them to a new workbook? You mean a blank workbook? Why not just save the workbook to a new name and delete all the data?

 

[Nanogirl21]

Are all macros in one workbook? And you want to move all of them to a new workbook? You mean a blank workbook? Why not just save the workbook to a new name and delete all the data?

No, they are not all in 1 workbook. There are 7 workbooks and I need to combine all macros that are in those 7 into one "master" workbook.

 

[Nanogirl21]

You could first copy them all into a single module, then you've only got to export that 1 and import it.

How would this work? I've never used multiple macros with only 1 single module. Wouldn't the codes all mesh together and become 1 massive blob? I will still need to run the macros individually.

 

[Fluff]

The quickest way I now off, is to drag & drop the modules in the VBA project window.

 

[jmacleary]

How would this work? I've never used multiple macros with only 1 single module. Wouldn't the codes all mesh together and become 1 massive blob? I will still need to run the macros individually.

Providing each macro has a unique name, you can have as many different macros in 1 workbook/module as you like. So you can open each workbook and copy all their macros into your master workbook module.