Hi Nav,

See Ron de Bruin's sample code at:

Copy a range from closed workbooks (ADO)
http://www.rondebruin.nl/ado.htm



---
Regards,
Norman


"Nav" wrote in message
...
Hello

I have 10 files (1 per person- S:\data\(initials)) they have the same
format
(1st four columns) with data in them with the first row as a header. I
wish
to create 1 file for all this data, is there an easy way to obtain the
data
from all the files and create a new one under S:\data\combined without
having
to open then all 1 by one and copy and insert the cells into the new
combined
file (the data range also changes on a day to day basis).

Please can you provide suggestions, thank you in advance for your help.

Regards.