Include today's date in csv file name

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

Guest

I'm using transfertext macro to create a .csv file. I need to include
today's date as part of the file name. So the structure of the file name
would be:
[ Standard Prefix][today's date].csv

How do I get it to add today's date?

Thank you!
Cathy
 
Use an expression for the FileName argument:

="C:\MyFolderName\" & Format(Date(),"mmddyyyy") & ".csv"
 
Thanks Ken!

You are right on the mark... as always!



Ken Snell (MVP) said:
Use an expression for the FileName argument:

="C:\MyFolderName\" & Format(Date(),"mmddyyyy") & ".csv"

--

Ken Snell
<MS ACCESS MVP>

Cathy said:
I'm using transfertext macro to create a .csv file. I need to include
today's date as part of the file name. So the structure of the file name
would be:
[ Standard Prefix][today's date].csv

How do I get it to add today's date?

Thank you!
Cathy
Click to expand...
Click to expand...
 
Back
Top