check for latest backup file

[dialup]

I have a intranet tool which backs up to a csv file every 20 minutes.

When the tool goes down i want to import the data into a set of excel spreadsheets.

the files are named
"Backup" and the date and the time

Backup-2009-02-20-23-40.csv
Backup-2009-02-21-00-00.csv
Backup-2009-02-21-00-20.csv
Backup-2009-02-21-00-40.csv
Backup-2009-02-21-01-00.csv
Backup-2009-02-21-01-20.csv
Backup-2009-02-21-01-40.csv

etc

I have figured out how to get the backup-2009-02-21 (no matter how you format a date vba sees it seperated with/) but want to identify the latest back up for that day.

Can this be done with a macro?

 

[ColinKJ]

Hi dialup,

You could run a macro to read and load the file names into sheet and sort them in Decending order, then take the top one for loading

ColinKJ

 

[dialup]

so i just decided to present a userform with 2 comboboxes, one for the hours and the other for the minutes and let the users pick the time themselves