FileFormat Property
This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
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