Edit

Share via

Workbook.FileFormat property (Excel)

  • Article

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.