Hi Jay
Start here
http://www.rondebruin.nl/copy3.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl
"jay" wrote in message ...
I have 100+ files in the name of DEPTxxx.xls - where xxx is the number. Can
I open all of them or at least get the contents copied to a worksheet in my
active document rather than one at a time? Each of the files or individual
workbook contains two worksheets - the values from the individual workbooks
will be copied to another worksheet that represent a summary. Any idea's?