Hi Group;

I have a WorkBook with a tremendous amount of Macro Code. My
supervisors decided to give me a new WorkBook. I have to use the data from
the new WorkBook but need the Macros from my old WorkBook. Both Excel
WorkBooks have the same name. I am sure I will probably have to re-name one
of them, but how do I get the Macro Code from my Old WorkBook into my new
WorkBook automatically. I know I can copy the code and repaste it, but if
one of the office workers has to do this again, I would like to automate the
process.

Thanks in Advance;

J. Quinn

There used to be a way to do this easily through code, but with current
security setting i've found it to be just as big of a pain to change all the
settings. The easiest is to right click and export each, then import
manually. If you want to try the other way check out chip pearson's site
http://www.cpearson.com/excel/vbe.htm
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"John Quinn" wrote:

Hi Group;

I have a WorkBook with a tremendous amount of Macro Code. My
supervisors decided to give me a new WorkBook. I have to use the data from
the new WorkBook but need the Macros from my old WorkBook. Both Excel
WorkBooks have the same name. I am sure I will probably have to re-name one
of them, but how do I get the Macro Code from my Old WorkBook into my new
WorkBook automatically. I know I can copy the code and repaste it, but if
one of the office workers has to do this again, I would like to automate the
process.

Thanks in Advance;

J. Quinn