| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time Stamp | Excel Discussion (Misc queries) | |||
| Excel 2007 Changes date stamp on Save As | Excel Discussion (Misc queries) | |||
| Excel 2007 Changes date stamp on Save As | Excel Discussion (Misc queries) | |||
| product date stamp file save | Excel Discussion (Misc queries) | |||
| How can you save a spreadsheet with a date stamp. | Excel Worksheet Functions | |||
Hybrid Mode
