macro to open files in specific order

Hello everybody,

It would be fantastic if someone could help me.

I am looking for a macro to open a file, copy and paste data to master file, close file.
Then repeat this process for the next day until today's day or a specified
day.

I have listed the files in a separate sheet. Each file name contains the date of the dataset e.g.

data20120314.csv
data20120315.csv
data20120318.csv (no data for weekends)

The macro should be
lookup current date of last dataset, then open the file in the row below,
import data and close file,
then repeat (loop?) until a specific date = file name.

Thank you

Patrick

I think the following code is maybe 95% of what you asked for.

Please Login or Register  to view this content.