Export text with current date

  • Thread starter Thread starter Senthil
  • Start date Start date
S

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.
 
Hi,
also from Australia is an answer for you
strFileName = "queryName" & "_" & Format(Date, "dd-mm-yyyy")

Jeanette Cunningham
 
Back
Top