Skip to Content
0

OLE EXCEL do not save and process is still open HELP

May 17 at 12:18 PM

35

avatar image
Former Member

Hi i open an existing excel file and after that all i want to save it (not save as!).

I don't know what's wrong. Also the process is still open (Excel-Process).

My code: (not all)

data: e_sheet type ole2_object,
e_appl type ole2_object,
e_work type ole2_object,
e_cell type ole2_object,

*--------------------------------------------------------------------*
Form starte_excel.
*--------------------------------------------------------------------*

create object e_appl 'EXCEL.APPLICATION'.

set property of e_appl 'VISIBLE' = 0.

call method of e_appl 'WORKBOOKS' = e_work.

call method of e_work 'OPEN'

exporting #1 = p_file.

Endform.
*--------------------------------------------------------------------*

*--------------------------------------------------------------------*
Form beende_excel.
*--------------------------------------------------------------------*

Call METHOD of e_appl 'Activesheet' = e_sheet.

Call method of e_sheet 'Save'.

Call METHOD of e_work 'Close'.

Call METHOD of e_appl 'Quit'.

Free Object e_appl.


Endform.
*--------------------------------------------------------------------*

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers