I need to pull data from a daily generated excel file, with a changing
file name. The file will always be in the same location.

I ran the connection info on the excel file I would like to hit (tip --
see this useful thread he
http://groups.google.ca/group/comp.d...c993a4/?hl=en#
or tips on gathering the connection information and SQL from a broken
query) and it came back with this:

ODBC;DSN=Excel Files;DBQ=C:\ExcelFiles\ExcelFile - Mar. 2,
07.xls;DefaultDir=C:\ExcelFiles
\;DriverId=790;MaxBufferSize=2048;PageTimeout=5;

What I want to do is refresh a query with a piece of VBA so that it
will always pull in the ExcelFile of the current date [ie "Excelfile -
" & format(date, "Mmm. dd, yy") & ".xls" ]

Can anyone help with that?