Export text with current date

[Senthil]

hi,

I want to export a few queries to text files. I am current using "transfer
text" option through macros. If we provide the file name and the path the
files are exported to the path. How do we add the current date at the end of
each file.

eg. abc is the query name & i want the query to be exported as data_25122007.

Currently i am able to get the file name as data_. the date should be
dynamic (ie) should give the current date at the end of the file.

Any ideas, Pls help.

 

[Jeanette Cunningham]

Hi,
also from Australia is an answer for you
strFileName = "queryName" & "_" & Format(Date, "dd-mm-yyyy")

Jeanette Cunningham