FileFormat List

[Barb Reinhardt]

Is there a list of file formats and the numeric equivalent for the different
Excel extensions available in 2007 (and 2003)? I'm using this in a SaveAs
command and want to make sure I've covered my bases.

Thanks,
Barb Reinhardt

 

[Peter T]

following in all versions since 2000
xlAddIn 18
xlCSV 6
xlCSVMac 22
xlCSVMSDOS 24
xlCSVWindows 23
xlDBF2 7
xlDBF3 8
xlDBF4 11
xlDIF 9
xlExcel2 16
xlExcel2FarEast 27
xlExcel3 29
xlExcel4 33
xlExcel5 39
xlExcel7 39
xlExcel9795 43
xlExcel4Workbook 35
xlIntlAddIn 26
xlIntlMacro 25
xlWorkbookNormal -4143
xlSYLK 2
xlTemplate 17
xlCurrentPlatformText -4158
xlTextMac 19
xlTextMSDOS 21
xlTextPrinter 36
xlTextWindows 20
xlWJ2WD1 14
xlWK1 5
xlWK1ALL 31
xlWK1FMT 30
xlWK3 15
xlWK4 38
xlWK3FM3 32
xlWKS 4
xlWorks2FarEast 28
xlWQ1 34
xlWJ3 40
xlWJ3FJ3 41
xlUnicodeText 42
xlHtml 44

following n/a in 2000, new in 2002 or 2003, not sure which
xlWebArchive 45
xlXMLSpreadsheet 46

the following are new in 2007
xlExcel12 50
xlOpenXMLWorkbook 51
xlOpenXMLWorkbookMacroEnabled 52
xlOpenXMLTemplateMacroEnabled 53
xlTemplate8 17
xlOpenXMLTemplate 54
xlAddIn8 18
xlOpenXMLAddIn 55
xlExcel8 56
xlWorkbookDefault 51

Regards,
Peter T

 

[Dave Peterson]

Inside the VBE, hit F2 to see the object browser.
Search for Fileformat

You'll see the list of constants and their numeric values.

=====
Ron de Bruin has a subset of that list used in code:
http://www.rondebruin.nl/saveas.htm