View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jef Gorbach Jef Gorbach is offline
external usenet poster
 
Posts: 59
Default macro to copy other macros between workbooks?

Each month, several reports are exported from a database into new excel
workbooks which are then combined into a single workbook as seperate tabs
for futher processing by a series of macros which are manually copied from
the proceeding month's file to keep the files "stand-alone" and independent
of a given system's personal.xls.

Is it possible, for vba to copy all/certain modules from Reports_Jan05.xls
to Reports_Feb05.xls ??
This macro could either be within personal.xls or called from the prior
month's file.