Extract Data out of directory to one excel file

[jambai20]

Hi All
Not sure if someone can perhaps help.I know what I am asking definitely can be done as I have seen it before ,but just forgotten the exact details on the code.
I have 9 excel files in a shared drive in the same folder named the same and format everyday ,just different date for each new day.The files are run every night and for each day I need to go into the 9 files and extract what's is in them and paste into one file with 9 different tabs for each file.So I need a macro when you enter your date in the macro it will go extract the data for that date and will paste the data into my one main file into 9 different tabs.Anybody got any ideas .Much appreciated.

 

[jambai20]

Hi All
Not sure if someone can perhaps help.I know what I am asking definitely can be done as I have seen it before ,but just forgotten the exact details on the code.
I have 9 excel files in a shared drive in the same folder named the same and format everyday ,just different date for each new day.The files are run every night and for each day I need to go into the 9 files and extract what's is in them and paste into one file with 9 different tabs for each file.So I need a macro when you enter your date in the macro it will go extract the data for that date and will paste the data into my one main file into 9 different tabs.Anybody got any ideas .Much appreciated.

Hi any ideas on above?

 

[poolhall]

this could help you: http://www.rondebruin.nl/ado.htm

 

[jambai20]

this could help you: http://www.rondebruin.nl/ado.htm

Thanks ,has some useful info there that I will play around with.Only thing I am missing is where I can put in the date that I would like to extract.Format the same always ,so how could that be put into the code?

Thanks very much