Excel macros

[Guest]

I want to copy an entire macro module from a workbook to a new workbook and save it into my PERSONAL WORKBOOK so I can run the macro anytime I need to but when I use the Project Explorer function to copy it over, I do not get prompted on which workbook I can save it into (like when you record a new macro).

Or perhaps this question can be simplified as

Can I save a macro from a "this workbook" to a "personal workbook".

I hope this makes sense

I realize the time I have spent on this, I probably could have simply rerecorded the original macro and given it a new name and be done with it but this is driving me nuts.

 

[Paul B]

Mike, You can drag and drop the macros from one workbook to another in the
VBA editor, just open the workbooks and drag and drop. Or if it on another
computer you can export a macro and save it, to do this from your workbook,
right-click the workbook's icon and pick View Code. This icon is to the left
of the "File" menu this will open the VBA editor, click on the module you
want to save and go to file and export file, then save it to a floppy or
what ever you backup to, then import it to the new workbook.
--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

I want to copy an entire macro module from a workbook to a new workbook

and save it into my PERSONAL WORKBOOK so I can run the macro anytime I need
to but when I use the Project Explorer function to copy it over, I do not
get prompted on which workbook I can save it into (like when you record a
new macro).

Or perhaps this question can be simplified as:

Can I save a macro from a "this workbook" to a "personal workbook".

I hope this makes sense.

I realize the time I have spent on this, I probably could have simply

rerecorded the original macro and given it a new name and be done with it
but this is driving me nuts.

 

[Cesar Zapata]

I guess you need to Export it then import it to your persnoal workbook.


Regards.

Cesar Zapata

I want to copy an entire macro module from a workbook to a new workbook

and save it into my PERSONAL WORKBOOK so I can run the macro anytime I need
to but when I use the Project Explorer function to copy it over, I do not
get prompted on which workbook I can save it into (like when you record a
new macro).

Or perhaps this question can be simplified as:

Can I save a macro from a "this workbook" to a "personal workbook".

I hope this makes sense.

I realize the time I have spent on this, I probably could have simply

rerecorded the original macro and given it a new name and be done with it
but this is driving me nuts.

 

[Guest]

Thanks for the prompt replies gentlemen