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