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