Importing Files into Excel

J

justin.a.moran

Heres my goal. I have a directory full of .xls files. I would like to
merge all these files in said directory into one master file. Doing
this through a macro would be prefered because importing each file
individually would take about 2 months to complete :) Any help with
this? Im new to macro's
 
A

Ardus Petus

It all depends on how your .xls files are structured, and how you want the
resulting file to be structured.
Same # of columns in original .xls files
One/many worksheets
etc...

HTH
 
W

wmureports

All of the xls files are formatted exactly the same. I want the format
to stay the same, I just want to merge the data from lets say 1000 .xls
files into one. All the files are in one directory.
 
Top