export query adding date to file name

[626]

I'm trying to export a query to excel daily, and exporting is not the probelm, but I need the file name to have time stamped with the yyyy/mm/dd so as to avoid over writing the file everyday. Does some have any ideas

Thanks a lot

 

[bustell]

Use the Name command. You will need to execute the query from VB and then use the following command substituing the filenames

name "C:\test.txt" as "C:\test" & format(date,"yyyymmdd&quot & ".txt"

I would also recommend not putting slashes in the file name even if they are forward slashes. It could look confusing.
Pat B