Save as a macro enabled template

[dcoledc]

I am trying to save a macro enabled template as a template.

For example, I have a workbook called Test.xltm and I want a macro within it to save over it, instead of calling Test1.xls.

The code I am trying to use to no avail is:

ThisWorkbook.SaveAs FileName:="Test.xltm"

I get errors. Anyone know how to do what I am trying to do.

Just so you know, I want to be able to update a few things and then save as template so later when I go in I don't accidently save changes I didn't mean to.

 

[Nalani]

You don't say what errors your getting. Or if you have other bits of code that may be throwing errors.

But assuming that you are getting an error saying .... that the file format or extension is not valid ....

Try adding this to the end of your SaveAs code:

ThisWorkbook.SaveAs Filename:="TestA.xltm", FileFormat:= _
        xlOpenXMLTemplateMacroEnabled

 

[dcoledc]

You are correct in the error I was getting. Thanks for the info. I will give it a try.

 

[dcoledc]

Perfect!