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.
*--------------------------------------------------------------------*