How to Move Macros from one workbook to another

[patriciaanne]

Hi There- Anyone know an easy way to move macros from one workbook to another without first creating a new macro name and then copying and pasting each one in?
Thanks for your help.


To everything there is a season, a time for every purpose under the sun.

 

[SkipVought]

Hi,

Why would you create a new name?

What about a PERSONAL.xls workbook for ALL commonly accessed macros?

Copy just one macro or the entire module?

Inquiring minds want to know.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[combo]

Open two workbooks and drag modules/userforms between vba projects (project explorer window). For workbook/sheet modules only copy&paste method works.

combo

 

[patriciaanne]

Sorry... I wrote the macros for another person so the personal workbook won't work. Ok.. I'll copy and paste- thanks.

To everything there is a season, a time for every purpose under the sun.

 

[Gavona]

I save shared macros in a (read only) workbook in the shared folder. My Personal.xls simply opens this file.

Gavin

 

[JA3395]

If you right-click on a module you can export the module to a BAS file. You can then import this BAS file into any workbook you want.