ExcelBanter - Save as w/ Time Stamp

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Save as w/ Time Stamp (https://www.excelbanter.com/excel-programming/323717-save-w-time-stamp.html)

Arturo

Save as w/ Time Stamp

ActiveWorkbook.SaveAs Filename:= _
"UpLoad-" & Now & ".txt", _
FileFormat:=xlText, CreateBackup:=False

I am not seeing how to format the characters generated from €œNow€ to allow a
valid save€¦

Perplexed,
Arturo

Steve[_74_]

Save as w/ Time Stamp

Depends what you wish to get.

"UpLoad-" & Format(Now, "YYYY-MM-DD-hh:mm") & ".txt"

will give you:

UpLoad-2005-02-22-11:29.txt

"Arturo" wrote in message
...
ActiveWorkbook.SaveAs Filename:= _
"UpLoad-" & Now & ".txt", _
FileFormat:=xlText, CreateBackup:=False

I am not seeing how to format the characters generated from "Now" to allow
a
valid save.

Perplexed,
Arturo

Arturo

Save as w/ Time Stamp

Thanks Steve.
I just needed to adjust the :
Arturo

"Steve" wrote:

Depends what you wish to get.

"UpLoad-" & Format(Now, "YYYY-MM-DD-hh:mm") & ".txt"

will give you:

UpLoad-2005-02-22-11:29.txt

"Arturo" wrote in message
...
ActiveWorkbook.SaveAs Filename:= _
"UpLoad-" & Now & ".txt", _
FileFormat:=xlText, CreateBackup:=False

I am not seeing how to format the characters generated from "Now" to allow
a
valid save.

Perplexed,
Arturo

All times are GMT +1. The time now is 07:07 AM.