Importing Files into Excel
 

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

Importing Files into Excel
 

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

Importing Files into Excel
 

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