http://www.cpearson.com/excel/vbe.htm

on Chip Pearson's site should address this. You would have to export it
from Jan and import it into Feb

--
Regards,
Tom Ogilvy

"Jef Gorbach" wrote in message
...
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.