I have several macros that need to be run in progression. Combining them
would make for too long macros. The problem is that when the second macro is
called, all memory is lost (wbk1 = "xxxxxxx.xls") etc. Is there a global
declaration that can be made for each macro in the progression to keep the
assignments?

Thanks,

Jim