[RESOLVED] Excel FileFormat

[gavio]

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

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

[Hack]

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

[gavio]

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

Thank you!

-gav

[RobDog888]

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