I have got 40 separate files in a folder. One for each month from Ma
2000 to Sept 2004 - All named like "yyyy mm SRnA.xls". Every file ha
only a single sheet. Is there a way in VBA to loop through all file
to create a copy of all sheets in one new workbook?

Thanks,
Jorda

--
jordanct
-----------------------------------------------------------------------
jordanctc's Profile: http://www.excelforum.com/member.php...nfo&userid=676
View this thread: http://www.excelforum.com/showthread.php?threadid=26934