XlFileFormat enumeration (Excel)
Specifies the file format when saving the worksheet.
| Name | Value | Description | Extension |
|---|---|---|---|
| xlAddIn | 18 | Microsoft Excel 97-2003 Add-In | *.xla |
| xlAddIn8 | 18 | Microsoft Excel 97-2003 Add-In | *.xla |
| xlCSV | 6 | CSV | *.csv |
| xlCSVMac | 22 | Macintosh CSV | *.csv |
| xlCSVMSDOS | 24 | MSDOS CSV | *.csv |
| xlCSVUTF8 | 62 | UTF8 CSV | *.csv |
| xlCSVWindows | 23 | Windows CSV | *.csv |
| xlCurrentPlatformText | -4158 | Current Platform Text | *.txt |
| xlDBF2 | 7 | Dbase 2 format | *.dbf |
| xlDBF3 | 8 | Dbase 3 format | *.dbf |
| xlDBF4 | 11 | Dbase 4 format | *.dbf |
| xlDIF | 9 | Data Interchange format | *.dif |
| xlExcel12 | 50 | Excel Binary Workbook | *.xlsb |
| xlExcel2 | 16 | Excel version 2.0 (1987) | *.xls |
| xlExcel2FarEast | 27 | Excel version 2.0 Asia (1987) | *.xls |
| xlExcel3 | 29 | Excel version 3.0 (1990) | *.xls |
| xlExcel4 | 33 | Excel version 4.0 (1992) | *.xls |
| xlExcel4Workbook | 35 | Excel version 4.0. Workbook format (1992) | *.xlw |
| xlExcel5 | 39 | Excel version 5.0 (1994) | *.xls |
| xlExcel7 | 39 | Excel 95 (version 7.0) | *.xls |
| xlExcel8 | 56 | Excel 97-2003 Workbook | *.xls |
| xlExcel9795 | 43 | Excel version 95 and 97 | *.xls |
| xlHtml | 44 | HTML format | *.htm; *.html |
| xlIntlAddIn | 26 | International Add-In | No file extension |
| xlIntlMacro | 25 | International Macro | No file extension |
| xlOpenDocumentSpreadsheet | 60 | OpenDocument Spreadsheet | *.ods |
| xlOpenXMLAddIn | 55 | Open XML Add-In | *.xlam |
| xlOpenXMLStrictWorkbook | 61 (&H3D) | Strict Open XML file | *.xlsx |
| xlOpenXMLTemplate | 54 | Open XML Template | *.xltx |
| xlOpenXMLTemplateMacroEnabled | 53 | Open XML Template Macro Enabled | *.xltm |
| xlOpenXMLWorkbook | 51 | Open XML Workbook | *.xlsx |
| xlOpenXMLWorkbookMacroEnabled | 52 | Open XML Workbook Macro Enabled | *.xlsm |
| xlSYLK | 2 | Symbolic Link format | *.slk |
| xlTemplate | 17 | Excel Template format | *.xlt |
| xlTemplate8 | 17 | Template 8 | *.xlt |
| xlTextMac | 19 | Macintosh Text | *.txt |
| xlTextMSDOS | 21 | MSDOS Text | *.txt |
| xlTextPrinter | 36 | Printer Text | *.prn |
| xlTextWindows | 20 | Windows Text | *.txt |
| xlUnicodeText | 42 | Unicode Text | No file extension; *.txt |
| xlWebArchive | 45 | Web Archive | *.mht; *.mhtml |
| xlWJ2WD1 | 14 | Japanese 1-2-3 | *.wj2 |
| xlWJ3 | 40 | Japanese 1-2-3 | *.wj3 |
| xlWJ3FJ3 | 41 | Japanese 1-2-3 format | *.wj3 |
| xlWK1 | 5 | Lotus 1-2-3 format | *.wk1 |
| xlWK1ALL | 31 | Lotus 1-2-3 format | *.wk1 |
| xlWK1FMT | 30 | Lotus 1-2-3 format | *.wk1 |
| xlWK3 | 15 | Lotus 1-2-3 format | *.wk3 |
| xlWK3FM3 | 32 | Lotus 1-2-3 format | *.wk3 |
| xlWK4 | 38 | Lotus 1-2-3 format | *.wk4 |
| xlWKS | 4 | Lotus 1-2-3 format | *.wks |
| xlWorkbookDefault | 51 | Workbook default | *.xlsx |
| xlWorkbookNormal | -4143 | Workbook normal | *.xls |
| xlWorks2FarEast | 28 | Microsoft Works 2.0 Asian format | *.wks |
| xlWQ1 | 34 | Quattro Pro format | *.wq1 |
| xlXMLSpreadsheet | 46 | XML Spreadsheet | *.xml |
See also:
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.