[RESOLVED] Excel FileFormat

When i'm saving my workbook created through VB with:

Code:

---

myWorkBook.SaveAs "c:\someFile.xls", [fileFormat]

---

... and i want the file format to be Excel 97-2003... what format should i use? Cause there is no xlExcel11, only xlExcel12 (2007). Should i use xlExcel8?

-gav

I think xlExcel8 is the closest you are going to get.

I believe Excel 8 is equivalent to Excel 97 - so, it looks ok :)

It also seems MS haven't done anything with it for 10 years :duck:

Thank you!

-gav

There is only up to Excel 97 format.

Const xlExcel8 = 56

Then it goes to Excel 2007 format.

Const xlExcel12 = 50

And if your not sure you can always use the default format of what is instanned on the system.

Const xlWorkbookNormal = -4143