Application.DefaultSaveFormat Property (Excel)
Returns or sets the default format for saving files. For a list of valid constants, see the FileFormat property. Read/write Long.
Syntax
expression .DefaultSaveFormat
expression A variable that represents an Application object.
Example
This example sets the default format for saving files.
Application.DefaultSaveFormat = xlExcel4Workbook