export query and add date to file name?

[George]

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

 

[Pat Hartman\(MVP\)]

Not in a macro but you can with the TransferSpreadsheet Method.

 

[John Nurick]

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.

 

[Pat Hartman\(MVP\)]

I was assuming that more of the name was variable than just the date.