View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Steve[_74_] Steve[_74_] is offline
external usenet poster
 
Posts: 39
Default 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