Saving from template to new file without the vb code

[MyD0j0]

Thanks for the help.

From xl help, I thought I understood that templates allowed creating a
new file that included formatting, style, text, etc. This does not
seem the case, as when saving, the template is saved with whatever
modifications have been made using some code, which in my mind
contradicts the purpose of a template. I understand from help, that
the template needs to be in a default template directory and saved as
using the file type setting; though I have saved as using the file
type setting set to template, the default/alternate locations are not
feasible yet I still need the template to act like a template.

So there is a xlt file with code. When the code runs, I would like a
new file to save without any of the vb code that is in the template.
I have used .SaveCopyAs and .saveas and do not get these results. Is
there a way to save to a new file just the formatting, etc without any
of the code?


Thanks again.