DefaultSaveFormat Property
Returns or sets the default format for saving files. For a list of valid constants, see the FileFormat property. Read/write Long.
Example
This example sets the default format for saving files.
Application.DefaultSaveFormat = xlExcel4Workbook