Hi all, i have approx 35 xls files with only one worksheet in per
workbook. What i need to do is to create a summary workbook containing
the data from all the worksheets. I would normally have done this by
opening the file and selecting all from A2 down and then copied it onto
a new sheet and then just added the data from each sheet underneath the
data already there. Can one do this with the workbooks closed ? If so
how would one do that ? any help with code would be appreciated.



Les Stout

*** Sent via Developersdex http://www.developersdex.com ***