topic Re: OLE in Application Development and Automation Discussions

OLE

Former Member — Thu, 28 Oct 2010 13:26:18 GMT

I have defined

data: lw_templ_wbook TYPE ole2_object.

CALL METHOD OF lw_templ_wbook 'SAVE'.

IF sy-subrc >< 0.

PERFORM f800_append_message USING text-e07

CHANGING gf_error gi_msg.

EXIT.

ENDIF.

here I am getting sy-subrc eq 2.

what can be cause and how to correct it.

Moderator message: please use more descriptive subject lines from now on.

Edited by: Thomas Zloch on Oct 28, 2010 3:30 PM

Former Member — Fri, 29 Oct 2010 07:49:25 GMT

data: go_excel type ole2_object,

go_workbook TYPE OLE2_OBJECT,

****INITIATE EXCEL

create object go_excel 'EXCEL.APPLICATION'.

set property of go_excel 'Visible' = 0.

call method of go_excel 'WORKBOOKS' = go_workbook .

call method of go_workbook 'Add' = go_workbook.

**CLOSE EXCEL**********

CALL METHOD OF go_workbook 'SaveAs'

EXPORTING #1 = gv_file

#2 = 1.

Former Member — Fri, 29 Oct 2010 09:41:46 GMT

Done

Former Member — Fri, 29 Oct 2010 15:23:40 GMT

Hi Suchender,

Thank you

Jan

Edited by: Thomas Zloch on Oct 29, 2010 5:26 PM - please do not ask for ...