Importing / updating most recent datafile

I will be recieving daily .csv files that I want to import into my model as efficiently and accurately as possible.

The two files are EXTRACT1_date and EXTRACT2_date, such that I will have a library that looks like this:

EXTRACT1_052108
EXTRACT2_052108
EXTRACT1_052208
EXTRACT2_052208
EXTRACT1_052308
EXTRACT2_052308 etc.

Is there a way I can set the data import wizard to pick the most recent files and import them on launch?

I am not sure if it matters, but I will be opening EXTRACT1 on the first tab of my workbooks and EXTRACT2 on the second. Another workbook will be linked to this worksheets and will contain the model logic.

Thank you for looking!

A couple of questions...

Do you mean most recent files?

How is your date formated - what does the 5 refer to?

Yes, I did mean most recent file.

The 5 stands for May. The file may be 05 (for May), but I am not sure at this point. Actually, I could probably have the files named anything I want if that would help the process any.

Thanks,
C

So this means then that you want the most recent file determined by the date time stamp as opposed to the file name?

Try this macro

Please Login or Register  to view this content.

You'll need to adjust it for your folder location and sheet names.