I regulary download a spreadsheet which has a filename format of
Data_Date_Time.xls

For example SurveyData_290905_1105.xls

Each downloaded file has identical column structure but a variable number of
rows.

I have another spreadsheet analysis.xls that does all the calculations.

I'm trying to work out the best way of being able to download the latest
data file and then for the analysis to be done on that file - without having
to set up all the links from scratch.

Suggestions will be welcome (although writing VBA is well beyond my current
position on my learning curve).

TIA

Rob