Automatically rename a template sheet with today's date.

[MasterBash]

Welcome to VBAX MasterBash. A quick correction if you don't mind. Templates cannot be saved as a template sheet. I refer to the following from Microsoft



Don't save data to a template. Open the template and save it as a new workbook with a xlsm format. With the new workbook, you can implement the following code

Sub NewNamedSheet1()
     Dim ws As Worksheet
     Dim NameCount As Long
     Dim NameBase As String
     NameBase = Format(Date, "mm.dd.yyyy")
     Sheets.Add(After:=Sheets(Sheets.Count)).Name = NameBase
End Sub

Maybe I was misunderstood, but I do not save data to a template. I create a workbook and when I right click -> Insert to insert a new sheet, then I select the template I created.

Thank you ! It opens a blank sheet with the correct date. Would it be possible to add the template to it too ? Lets say I put the template in the same directory as the workbook, would it be possible to load the template along with the code above ?
In other words, when adding a new sheet, it would change the sheet's name to the current date AND load the template to that sheet ?