Gather data from multiple excel files in mutiple folders
 

Hello,

I need some help to generate a macro that will gather data from mutiple
excel files (all named the same) that are all located in their own
subdirectory.

More explanation:

I want the user to be able to select one main directory for the month, it
contains daily subdirectories that each have an excel file named: "QC
Production Sheet". Within this file, they each have a worksheet named:
"Gqf44"

I would like the macro to gather all the information on these sheets (after
the user selects the main monthly directory) in each daily subdirectory and
copy it the the master excel file that will perform the overall summary.
Basically have it copy each worksheet into the master and name these
worksheets with the date that is entered in cell "C5" from the worksheets
that are being pulled.

Any help on this item is greatly appreciated.

Thanks in advance...

--
Mark Ivey

Gather data from multiple excel files in mutiple folders
 

You can try this
http://www.rondebruin.nl/fso.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Mark Ivey" wrote in message ...
Hello,

I need some help to generate a macro that will gather data from mutiple
excel files (all named the same) that are all located in their own
subdirectory.

More explanation:

I want the user to be able to select one main directory for the month, it
contains daily subdirectories that each have an excel file named: "QC
Production Sheet". Within this file, they each have a worksheet named:
"Gqf44"

I would like the macro to gather all the information on these sheets (after
the user selects the main monthly directory) in each daily subdirectory and
copy it the the master excel file that will perform the overall summary.
Basically have it copy each worksheet into the master and name these
worksheets with the date that is entered in cell "C5" from the worksheets
that are being pulled.

Any help on this item is greatly appreciated.

Thanks in advance...

--
Mark Ivey

Gather data from multiple excel files in mutiple folders
 

Ron,

I think I can work with this...

Thanks a million...

--
Mark Ivey
"Ron de Bruin" wrote in message ...
You can try this
http://www.rondebruin.nl/fso.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Mark Ivey" wrote in message ...
Hello,

I need some help to generate a macro that will gather data from mutiple
excel files (all named the same) that are all located in their own
subdirectory.

More explanation:

I want the user to be able to select one main directory for the month, it
contains daily subdirectories that each have an excel file named: "QC
Production Sheet". Within this file, they each have a worksheet named:
"Gqf44"

I would like the macro to gather all the information on these sheets (after
the user selects the main monthly directory) in each daily subdirectory and
copy it the the master excel file that will perform the overall summary.
Basically have it copy each worksheet into the master and name these
worksheets with the date that is entered in cell "C5" from the worksheets
that are being pulled.

Any help on this item is greatly appreciated.

Thanks in advance...

--
Mark Ivey