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

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

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.

Ardus Petus wrote:
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