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
--
AP

a écrit dans le message de news:
...
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