Thread: Save as w/ Time Stamp
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Arturo Arturo is offline
external usenet poster
  
Posts: 108
Default 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
Reply With QuoteReply With Quote