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
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With