View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default 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