Excel.Application SaveAs

[ndornacker]

I am calling the Excel.Application object. Problem is I need to save the workbook as an Excel 8 (Excel 2003) document. Any ideas on how this can be accomplished?

Thanks.

 

[mrobles]

vchWorkBook:SaveAs("c:\temp\sample.xlsx",,,,,,,).

 

[Rob Fitzpatrick]

If you want to create a binary .xls file (Excel 97 - 2003 format), you need to use file format XlExcel8 (or 56). FileFormat is the second parameter to the SaveAs method. So you want something like:

vchWorkBook:SaveAs("c:\temp\sample.xls",56,,,,,).

For a list of valid constants for this parameter, search the Excel or MSDN help for the XlFileFormat enumeration.

 

[mrobles]

chExcelApplication:activeWorkBook:Saveas('c:\data\wrk.csv', 24,,,,,).
chExcelApplication:activeWorkBook:Saveas('c:\data\wrk.xls', -4143 ,,,,,).