HELP: how to change default save-as type... in Excel...

  • Thread starter Thread starter KevinGPO
  • Start date Start date
K

KevinGPO

Does anyone know the VBA command in Excel to change the default "Save-As"
type? For example, if a template excel file is loaded, then the default
save-as type is template. I wrote a VBA script to save-as the template with
a .xls file-extension. Am not sure whether this automatically makes this
file a normal excel file, or whether it's still of type template. But then
when the user goes to save-as in this new excel file he still gets the
default type template.
 
Hi Kevin,

Try something like:

ActiveWorkbook.SaveAs Filename:="Your Name.xls", _
FileFormat:=xlWorkbookNormal
 
Why is a user opening the template if they don't want to save it as a
template?

Templates are intended to be the basis of a new workbook by using "New..."
not "Open...". Using "New..." doesn't open the template itself, it just
creates a new (non-template) workbook based on the template. A Template
never needs to be opened except to make design changes to the template, at
which point you would want to save it as a template again.

HTH,
 
Back
Top