Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FileFormat List
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
FileFormat List
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 "Barb Reinhardt" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
FileFormat List
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 Barb Reinhardt wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fileformat property compatibility | Excel Programming | |||
VBA Using FileFormat:=xlText | Excel Discussion (Misc queries) | |||
Excel SaveAs not using specified FileFormat | Excel Programming | |||
Default Excel FileFormat? | Excel Programming | |||
Fileformat XLText | Excel Programming |