| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
renaming a template file on startup
Hello,
how do I rename a template file after opening it, e.g. to the current date plus some extension? -- Johannes |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
renaming a template file on startup
Johannes,
You can't "rename" an open file, only save it with another filename. e.g. ThisWorkbook.SaveAs Format(Now(),"dd-mm-yyyy") & ".xls" Or .SaveCopyAs, depending on your needs. NickHK "Johannes Zellner" wrote in message .. . Hello, how do I rename a template file after opening it, e.g. to the current date plus some extension? -- Johannes |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Startup Template | Excel Discussion (Misc queries) | |||
| default template at startup | Excel Discussion (Misc queries) | |||
| Template Startup | Excel Discussion (Misc queries) | |||
| Excel Template Startup | Setting up and Configuration of Excel | |||
| How do you open a template at startup? | Excel Discussion (Misc queries) | |||
Linear Mode
