Keeping a Macro in a New Book

[Guest]

I have a workbook that contains a macro to save a copy of 2 tabs out on a
network drive, and then it loops, populates new data and saves those two tabs
again. The macro loops about 1200 times.

My issue is that on the second tab I want to have a macro that copies and
pastes data onto the second tab AFTER it has been saved off on to our network
away from the original spreadsheet it came from. I tried writing the macro
on the sheet (not in a module) but it wouldn't work (Runtime error 1004) -
but the exact same code worked if it was in a module. I do not believe the
module will migrate over when the 2 tabs are saved out - how can I make this
work?

(I posted this in the Worksheet Functions category on accident)

 

[Guest]

You could always have your code export the macro from the general module and
then import it into the new workbook created from the sheet.

http://www.cpearson.com/excel/vbe.htm will give you some ideas.