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
|