Export file to desktop with today's date added to the end of the file name
Posted on 2015-02-12
I'm using this code to attempt to export a file to the user's desktop WITH today's date in the file name. Like:
Mail List 02-12-02015.csv
but it isn't working.
Here's my line of code:
DoCmd.TransferText acExportDelim, , "qryExportMailList", strCSV & Environ("userProfile") & "\Desktop\" & "Mail List " & [txtToday] & ".csv"
which works fine until I add the & [txtToday] & to it.
What do I need to change the code to to make it work?