[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
Re: [RESOLVED] Excel FileFormat
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