Export table or Query with Date

[wmfrost]

How can I export a table or query with the current date appended to the end
or beginning of the file name?

 

[Klatuu]

= MyFileName & Format(date,"Short Date")
or what ever date format you want.

 

[Amy Blankenship]

I think you'd need Replace("/", "_", Format(Date,"Short Date")) & ".ext",
since you can't have a forward slash as part of a file name.

HTH;

Amy

 

[Lmanns]

My question is similar to this but I am trying to add the file extension
using TransferSpreadsheet in macros. Is there a way to do this? Can someone
walk me through doing it another way (keeping in mind my skilss are decent
but not expert!).

 

[Klatuu]

You are correct, Amy. I did not stop to think about that. Thanks for the
catch.