Hello all.

I have file saved to the same location every hour. The file will always have the same column layout but the numbers of rows may increase or decrease.

I want to import this data into another spreadsheet using a macro or linking directly in. However the name of the file with the data is different every time because it is saved with a date and time in its name.

How can I open or import ONLY from the newest file in the directory?

For example the file name is

DailyReportSales.201003020758.csv

Thanks

Andy