Instead of opening the template with the macro, create a new workbook
and use your template.
Workbooks.Add Template:="C:\YourTemplate.xlt"

HTH

Charles

KelliInCali wrote:
Hi... I open an excel template inside a macro and when I go to save, it
overwrites the template instead of creating new file. When I open the
template from Windows, it saves as a file. Anyone know why it behaves
differently inside the macro?

Thanks -kelli