vba - What is the correct `XlFileFormat` enumeration for Excel 97-2003

Question

In regards to Excel VBA Interop, what is the correct XlFileFormat enumeration for saving an Excel 97-2003 spreadsheet?

The official MSDN documentation is here but I can't figure out from reading this what the correct selection is.

Thanks

Answer 1

Excel 97 was version 8. Subsequent releases up to and including Excel 2003 had very minor changes. Until Excel 2007, version 12. Which is why you see xlExcel9 through 11 missing from the enumeration.

So you'll want xlExcel8 here.