Take a look at the INDIRECT function, it should give you what you
want.
S

"RFJ" wrote in message
...
| 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
|
|
|