FileFormat Property

Applies To

Workbook Object.

Description

Returns the file format and/or type of the workbook, as shown in the following list. Read-only.

xlAddIn

xlCSV

xlCSVMac

xlCSVMSDOS

xlCSVWindows

xlDBF2

xlDBF3

xlDBF4

xlDIF

xlExcel2

xlExcel3

xlExcel4

xlExcel4Workbook

xlIntlAddIn

xlIntlMacro

xlNormal

xlSYLK

xlTemplate

xlText

xlTextMac

xlTextMSDOS

xlTextWindows

xlTextPrinter

xlWK1

xlWK3

xlWKS

xlWQ1

xlWK3FM3

xlWK1FMT

xlWK1ALL


Remarks

The following additional formats are available in Far East Microsoft Excel: xlWJ2WD1, xlExcel2FarEast, and xlWorks2FarEast.

Example

This example saves the active workbook in Normal file format if its current file format is WK3.


If ActiveWorkbook.FileFormat = xlWK3 Then
    ActiveWorkbook.SaveAs fileFormat:=xlNormal
End If