Export (0) Print
Expand All
Expand Minimize

Workbook.FileFormat Property

Office 2007
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.

Visual Basic for Applications
If ActiveWorkbook.FileFormat = xlExcel9795 Then
    ActiveWorkbook.SaveAs fileFormat:=xlExcel12
End If



Community Additions

ADD
Show:
© 2014 Microsoft