combine multiple work books

[jsmonje]

I need to combine many (400+) worksheets into a master. they all hav
the same filename (fname.xls) and reside in unique directories.

i would love to just supply the macro with the root directory and le
the machine find all the files in the subs. but i can paste th
filenames in a sheet if necessary.

I need to grab from row 2 to the end from each workbook (they only hav
1 sheet) and copy to the master, and loop until anll the data has bee
combined.

I looked at Ron de Bruin's good info, and while it comes close, i ca
not figure out how to adapt it to my particular problem. Any hel
would be appreciated.

thanks

joh

 

[Otto Moehrbach]

John
You say that the file names are all the same but that each file resides
in a different directory. You also say that you could provide a list of the
file names in a sheet. I think you meant to say directory names.
With a list of directory names and a fixed file name, simply run a For
loop through all the directory names, open the first source file, copy the
sheet to the master file, close the source file, open the next source file,
and so on until you are done.
Come back with specific questions if you need help with this. HTH Otto

 

[Ron de Bruin]

Have you try Filesearch
http://www.rondebruin.nl/copy33.htm

Change .SearchSubFolders = False
to True

I need to grab from row 2 to the end from each workbook

On this page is a example
http://www.rondebruin.nl/copy3.htm#header