topic Re: OLE EXCEL OPEN PROBLEM in Application Development and Automation Discussions

OLE EXCEL OPEN PROBLEM

Former Member — Mon, 30 May 2011 06:29:28 GMT

Hi ,

I am uable to open by the following code , I just want to open excel withot any sheets in it.

can anybody help me out.

INCLUDE OLE2INCL.

DATA EXCEL TYPE OLE2_OBJECT.

CREATE OBJECT EXCEL 'Excel.Application'.

SET PROPERTY OF EXCEL 'Visible' = 1.

CALL METHOD OF EXCEL 'WORKBOOKS' = WORKBOOK.

CALL METHOD OF WORKBOOK 'Open' EXPORTING #1 = 'C:\EX1.XLS'.

Thanks,

Shaik.

Re: OLE EXCEL OPEN PROBLEM

Former Member — Mon, 30 May 2011 07:14:14 GMT

Hi,

why do you want to use OLE.

You can try this:



      CALL METHOD CL_GUI_FRONTEND_SERVICES=>EXECUTE
        EXPORTING
          DOCUMENT               = 'C:\EX1.XLS'

Regards, Dieter

Re: OLE EXCEL OPEN PROBLEM

former_member182670 — Mon, 30 May 2011 07:59:03 GMT

WORKBOOKS is a property not a method.

INCLUDE ole2incl.
DATA: excel TYPE ole2_object,
      workbook TYPE ole2_object.
CREATE OBJECT excel 'Excel.Application'.
GET PROPERTY OF  excel 'WORKBOOKS' = workbook.
CALL METHOD OF workbook 'Open' EXPORTING #1       = 'C:\book1.XLS'.
SET PROPERTY OF excel 'Visible' = 1.

If you want to open "empty" Excel remove the call of 'Open' method.