HMGforum.com

OEXCEL:WorkBooks:ADD("name of file.xls")

opens EXCEL and adds a new workbook

OEXCEL:WorkBooks:OPEN("name of file.xls")

opens an existing workbook

How does one

a) close and save
b) close and not save

Thanks

Hi Sunningdale,

Try:

oExcel:ActiveWorkbook:SaveAs( ( cFileName ) ) -- its working with Office 2007/2010

Commands that I didn't try yet:
oExcel:ActiveWorkbook:Close()

Regards,

Danny

THANKS VERY MUCH

OEXCEL:ACTIVEWORKBOOK:SAVEAS("C:\RJOD\HMGWORK\OLE\XYZ.XLS")
OEXCEL:ACTIVEWORKBOOK:CLOSE()
OEXCEL:QUIT()

all three work.

Your help is much appreciated.