Workbook.FileFormat Property (Excel)
Returns the file format and/or type of the workbook. Read-only XlFileFormat.
Syntax
expression .FileFormat
expression A variable that represents a Workbook object.
Remarks
Some of these constants may not be available to you, depending on the language support (U.S. English, for example) that you’ve selected or installed.
Example
This example saves the active workbook in Normal file format if its current file format is Excel 97/95.
If ActiveWorkbook.FileFormat = xlExcel9795 Then
ActiveWorkbook.SaveAs fileFormat:=xlExcel12
End If