Problem with saving Excel Template opened in macro
 

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

Problem with saving Excel Template opened in macro
 

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

Problem with saving Excel Template opened in macro
 

Works perfectly... even a little faster I think. Thanks!!
-kelli


"Die_Another_Day" wrote:

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