G
Guest
How can I export a table or query with the current date appended to the end
or beginning of the file name?
or beginning of the file name?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
= MyFileName & Format(date,"Short Date")
or what ever date format you want.
or what ever date format you want.
A
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
since you can't have a forward slash as part of a file name.
HTH;
Amy
G
Guest
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!).
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!).
G
Guest
You are correct, Amy. I did not stop to think about that. Thanks for the
catch.
catch.