I need to open 76 Excel files one at a time and copy the data on a ta
to a rollup workbook with 76 tabs. Is there a way to build an arra
with the names of the 76 workbooks and then change the pathname usin
the 76 names in the array so I can open each workbook, copy th
information to the rollup workbook, and close the individual workbooks
The workbooks are too large to open all of them and then copy the dat
to the rollup workbook!

TIA!!:

--
Message posted from http://www.ExcelForum.com