Export to Excel Using Date/Time Stamp

[RunTime91]

I figured Google would have had the answer - Nope...

Need to export from Access to Excel and save the file with Date/Time stamp...

I have tried several variations of the below code - and, well - I'm here.

DoCmd.TransferSpreadsheet acExport, , "QryTktRqstArch", "N:\Management\Internal\@DeptCommon\TEAMS\TktRequests\TktRequestFor_" & Format(Now(), "mm-dd-yyyy hh:mm") & ".xlsx", False

Receiving a 'can't save file' error...

Thanks as always...

[CJ_London]

the colon cannot be used in file names, along with /\?*"|<>

[RunTime91]

Oh Geez.... jsmh...

Thanks Aj

For future readers:

Solved With This:

DoCmd.TransferSpreadsheet acExport, , "QryTktRqstArch", "N:\Management\Internal\@DeptCommon\TEAMS\TktRequests\TktRequestFor_" & Format(Now(), "mm-dd-yyyy hhmm") & ".xlsx", False

[Micron]

Umm, can you transferspreadsheet into a file that doesn't exist? I don't believe so.
Don't see a problem with the colon either. It isn't part of the filename as far as I can see. It's part of the path, which should be ok.

EDIT: OK, so I copied both of the statements into notepad because I couldn't see a difference here. Even there, they look exactly the same, so how did the 'solution' work

[CJ_London]

"mm-dd-yyyy hh:mm"

became

"mm-dd-yyyy hhmm"

[Micron]

Wow. Need new glasses!
Thanks.