Save Excel Sheet

[Martin Dorfinger]

I can open and write to an Excel sheet, but how can I save this sheet?

Thanks

Martin

[Michael Mattias]

Unless I'm mistaken worksheets are not saved; you save the workbook.

There should be a method to call for saving a workbook.

[Martin Dorfinger]

Correct

you are right.

Any idea how to save it?

Martin

[John Petty]

From the samples
DIM vFile as Variant
LET vFile = "Test.Xls"
OBJECT CALL oExcelWorkSheet.SaveAs(vFile)
Actually whether it saves a workbook or single worksheet depends on what version of Excel compatability you specify, XLS extension version 4 and earlier was a single sheet, later a workbook

[Martin Dorfinger]

Thanks!