Excel Interop (Automation) and XlFileFormat: SaveAs v11 ?

[bill]

Folks,
The chart here: http://en.wikipedia.org/wiki/Microsoft_Excel#Versions

Shows for Windows, <b>Excel 2003</b>, is version <b>11</b>.

However, this chart: http://msdn.microsoft.com/en-us/lib....interop.excel.xlfileformat(v=office.14).aspx

Doesn't list <b>v11</b> as a possible save type... Is that because the <b>SaveAs</b> method offered though Automation of <b>v14</b> has an <b>XML</b> toggle when saving as <b>xlExcel12</b>, thereby inferring <b>v11</b> ?

If not, where are versions <b>9</b>, <b>10</b>, and <b>11</b> in enumaration? Are the file formats so similar that they are virtually the same <b>BIFF</b>?
Then really the only change to <b>9</b>, <b>10</b>, and <b>11</b> are with respect to the <b>GUI</b>?

If I wanted a file <b>100%</b> compatible with <b>v11</b>, what are my parameters?
Am I ultimately pointing to <b>xlExcel8</b>??

 

[bill]

Here's an informative link:

http://www.rondebruin.nl/saveas.htm

so I suppose <b>xlExcel8</b> is the way to go... !

 

[Norie]

bill

There is no enumeration for version, what you need for save as is the eumeration of file format (xlFileFormat).