FileFormat Property
Returns the file format and/or type of the workbook. Read-only XlFileFormat.
| XlFileFormat can be one of these XlFileFormat constants. |
| xlCSV |
| xlCSVMSDOS |
| xlCurrentPlatformText |
| xlDBF3 |
| xlDIF |
| xlExcel2FarEast |
| xlExcel4 |
| xlAddIn |
| xlCSVMac |
| xlCSVWindows |
| xlDBF2 |
| xlDBF4 |
| xlExcel2 |
| xlExcel3 |
| xlExcel4Workbook |
| xlExcel5 |
| xlExcel7 |
| xlExcel9795 |
| xlHtml |
| xlIntlAddIn |
| xlIntlMacro |
| xlSYLK |
| xlTemplate |
| xlTextMac |
| xlTextMSDOS |
| xlTextPrinter |
| xlTextWindows |
| xlUnicodeText |
| xlWebArchive |
| xlWJ2WD1 |
| xlWJ3 |
| xlWJ3FJ3 |
| xlWK1 |
| xlWK1ALL |
| xlWK1FMT |
| xlWK3 |
| xlWK3FM3 |
| xlWK4 |
| xlWKS |
| xlWorkbookNormal |
| xlWorks2FarEast |
| xlWQ1 |
| xlXMLSpreadsheet |
expression.FileFormat
expression Required. An expression that returns one of the objects in the Applies To list.
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 WK3.
If ActiveWorkbook.FileFormat = xlWK3 Then
ActiveWorkbook.SaveAs fileFormat:=xlNormal
End If