Include today's date in csv file name

[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

 

[Ken Snell \(MVP\)]

Use an expression for the FileName argument:

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

 

[Guest]

Thanks Ken!

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

Use an expression for the FileName argument:

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

--

Ken Snell
<MS ACCESS MVP>

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

 

[Ken Snell \(MVP\)]

Thanks Ken!

You're welcome.

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

Well, there have been a few (ok, a number of) times when the mark moved
before I hit it..... < g >