export query and add date to file name?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I would like to attach the date to the file name when i export a query. Is
this possible to do in a transfer spreadsheet macro? e.g file is called
"mm-dd-yyyy Account qry".
Thanks
George
 
It's possible to do this (at least in fine weather) in a macro by using
an expression like this for the "File Name" argument:

="C:\Temp\" & Format(Date(),"mm-ddyyyy") & " XXX.xls"

I seldom use macros and don't if there are any subtle gotchas.
 
Back
Top