Old Timer

[Ernie Hatton]

How do I SaveAs a template file with todays date as the file name

 

[yky]

ThisWorkbook.SaveAs Filename:="d:\test " & Format(Now(), "dd-mm-yy")

or just

ThisWorkbook.SaveAs Filename:="d:\" & Format(Now(), "dd-mm-yy")

 

[Ernie Hatton]

Not certain my reply was posted! Thanks for the code however it comes up with 'Compile Error: Syntax Error' I have assumed I can put in a path where you entered "d:". I have entered "C:\WWSC eRace" which is the path to where i want the file to be posted to.

 

[yky]

Probably need a full Sub, something like the following:

Sub Testsave()
[COLOR=#333333]ThisWorkbook.SaveAs Filename:="d:\" & Format(Now(), "dd-mm-yy")
[/COLOR]End Sub

 

[Ernie Hatton]

Thanks yky I made a school boy error, it works perfectly Many thanks