Declare Array in OLE Excel

[Former Member]

Dear all,

How can I declare a variable type Array in Excel Ole ABAP ??

Dim a As Variant

a = Array(11, 12)

How can I declare in ABAP ??

Thank you

[Former Member]

Note 633105 - OLE automation: ABAP type for OLE array parameters

Symptom

If the method of an OLE object contains an array parameter, there is no suitable ABAP data type for the parameter.

Reason and Prerequisites

Array is not supported as a data type for OLE parameters in ABAP.

Solution

None

[Pawan_Kesari]

Arrays can be represented in ABAP by internal tables with some effort.

Whether you can pass internal table to OLE method with an array as parameter is different story though.

Regards,

Pawan.

[mauro_calenda]

Hi everybody, I'm facing today this issue and I wonder if this limitation has been overcome. Any tips would be appreciated. CalMa