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

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

---
Regards,
Norman



"KevinGPO" <kevingpo@hotmail.com> wrote in message
news:eW06A8iLGHA.2992@tk2msftngp13.phx.gbl...
> 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.
>

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,
--
George Nicholson

Remove 'Junk' from return address.



"KevinGPO" <kevingpo@hotmail.com> wrote in message
news:eW06A8iLGHA.2992@tk2msftngp13.phx.gbl...
> 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.
>