Excel Ole problem

[Former Member]

I want to use the the OpenText method of the workbooks collection in Excel.

This method expects an array for the method parameter FieldInfo.

How do i pass an array to this parameter from ABAP ?

[Former Member]

Hi,

currently i have the same problem.

Did you find a solution?

thanks

Bernd

[Former Member]

Hi,

Is this what you want

• open file in Excel

IF application-header = space OR application-handle = -1.

CREATE OBJECT application 'Excel.Application'.

m_message.

ENDIF.

CALL METHOD OF application 'Workbooks' = workbooks.

• Open the Excel file

CALL METHOD OF workbooks 'Open' EXPORTING #1 = filename.

This will open the workbook.

regards,

theja.