topic Re: Excel Ole problem in Application Development and Automation Discussions

Excel Ole problem

Former Member — Wed, 07 Nov 2007 07:47:55 GMT

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 — Mon, 18 Feb 2008 13:31:09 GMT

Hi,

currently i have the same problem.

Did you find a solution?

thanks

Bernd

Former Member — Mon, 18 Feb 2008 13:40:10 GMT

Hi,

Is this what you want

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

CREATE OBJECT application 'Excel.Application'.

m_message.

ENDIF.

CALL METHOD OF application 'Workbooks' = workbooks.

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

This will open the workbook.

regards,

theja.