Hi,
I wonder what xlFileFormat value to use when saving a file using SaveAs with .XLSX, .XLSM, or .XLSB extension in Excel Automation. Any help would be greatly appreciated. Thanks.
_Workbook::SaveAs(const VARIANT& Filename, const VARIANT& FileFormat, const VARIANT& Password, const VARIANT& WriteResPassword, const VARIANT& ReadOnlyRecommended, const VARIANT& CreateBackup, long AccessMode, const VARIANT& ConflictResolution,
const VARIANT& AddToMru, const VARIANT& TextCodepage, const VARIANT& TextVisualLayout, const VARIANT& Local)
//xlAddIn 18 Microsoft Office Excel Add-In
//xlAddIn8 18 Excel 2007 Add-In
//xlCSV 6 CSV
//xlCSVMac 22 Macintosh CSV
//xlCSVMSDOS 24 MSDOS CSV
//xlCSVWindows 23 Windows CSV
//xlCurrentPlatformText -4158 Current Platform Text
//xlDBF2 7 DBF2
//xlDBF3 8 DBF3
//xlDBF4 11 DBF4
//xlDIF 9 DIF
//xlExcel12 50 Excel 12
//xlExcel2 16 Excel 2
//xlExcel2FarEast 27 Excel2 FarEast
//xlExcel3 29 Excel3
//xlExcel4 33 Excel4
//xlExcel4Workbook 35 Excel4 Workbook
//xlExcel5 39 Excel5
//xlExcel7 39 Excel7
//xlExcel8 56 Excel8
//xlExcel9795 43 Excel9795
//xlHtml 44 HTML format
//xlIntlAddIn 26 International Add-In
//xlIntlMacro 25 International Macro
//xlOpenXMLAddIn 55 Open XML Add-In
//xlOpenXMLTemplate 54 Open XML Template
//xlOpenXMLTemplateMacroEn
abled 53 Open XML Template Macro Enabled
//xlOpenXMLWorkbook 51 Open XML Workbook
//xlOpenXMLWorkbookMacroEn
abled 52 Open XML Workbook Macro Enabled
//xlSYLK 2 SYLK
//xlTemplate 17 Template
//xlTemplate8 17 Template 8
//xlTextMac 19 Macintosh Text
//xlTextMSDOS 21 MSDOS Text
//xlTextPrinter 36 Printer Text
//xlTextWindows 20 Windows Text
//xlUnicodeText 42 Unicode Text
//xlWebArchive 45 Web Archive
//xlWJ2WD1 14 WJ2WD1
//xlWJ3 40 WJ3
//xlWJ3FJ3 41 WJ3FJ3
//xlWK1 5 WK1
//xlWK1ALL 31 WK1ALL
//xlWK1FMT 30 WK1FMT
//xlWK3 15 WK3
//xlWK3FM3 32 WK3FM3
//xlWK4 38 WK4
//xlWKS 4 Worksheet
//xlWorkbookDefault 51 Workbook default
//xlWorkbookNormal -4143 Workbook normal
//xlWorks2FarEast 28 Works2 FarEast
//xlWQ1 34 WQ1
//xlXMLSpreadsheet 46 XML Spreadsheet
