File Format Numbers?

[chuggins143]

Anyone have a list for all of the file format numbers? I've done some poking around on the interwebsbut have only come up with the following... <o></o>
<o></o>
FileExtStr = ".xlsb": FileFormatNum = 50<o></o>
FileExtStr = ".xlsx": FileFormatNum = 51<o></o>
FileExtStr = ".xlsm": FileFormatNum = 52<o></o>
FileExtStr = ".xls": FileFormatNum = 56<o></o>
FileExtStr = ".csv": FileFormatNum = 6<o></o>
FileExtStr = ".txt": FileFormatNum = -4158<o></o>
FileExtStr = ".prn": FileFormatNum = 36<o></o>
<o></o>
When I “SaveAs” in Excel there are about 25+ options, I’m assumingthere are numbers for all of them… anyone have a full list? ..or know where I can reference one?
<o></o>
Thanks!<o></o>
<o></o>
Chad<o></o>

 

[misrasomendra]

May be going through Excel Help on this topic can fetch you what you want: [h=1]XlFileFormat Enumeration[/h]
Regards,

 

[Andrew Poulsom]

Or Google:

XlFileFormat Enumeration (Excel)

 

[chuggins143]

Thanks guys! Never would have thought to use the term "enumeration"! Much appreciated! C

 

[djreiswig]

Go to the object browser in the VB window (Press F2) and then type xlFileFormat in the Search Text box.