I use "TransferSpreadsheet" in Access (ACC2002) Macro Action to import an Excel file.

My problem is the Excel worksheet has data updated daily and are saved as different filenames (eg.in format DailyStock_ddmmyyyy.xls). I therefore do not want to automatically import a specified worksheet but I want Access to prompt me which Excel file to import from the folder C:\WeeklyData\Stock\

How can I do this ?

Any help is much appreciated.