KevinGPO
02-10-2006, 10:44 AM
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.
Norman Jones
02-10-2006, 10:57 AM
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.
>
George Nicholson
02-10-2006, 11:12 PM
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.
>