Opening an Excel Template and appending the current Date/Time to the file name

Currently, when I open a Template file (create a new file from a template) it will name that file *TemplateName*1

I am having users save these files to a folder each time they make a new one, and I don't want them to be overwritten. Is it possible to have the template saved as macro-enabled and have a VBA script that when that template is used, the file name is generated as *TemplateName**CurrentDateTime*?

I want to prevent overwritten and not have to have the saved document save as a Macro Enabled file.