How to call method excel subtotal in ABAP program

[Former Member]

I'm trying to call excel method subtotal, but i get an error (sy-subrc <> 0). How to correctly call this method? One of the parameters is an array. I've tried to use an internal table as the array, but ABAP syntax checker shows error.

[Former Member]

Hi Vytautas,

The best way is to start recording a Macro(Tools->Macro->Record New Macro), and then do the operations (like entering data into cells, summing up, calculations,etc...)

once you are done, display the macro and you will find all the needful information regarding what metohds are to be called and how...

Regards,

Raj

[Former Member]

I know about macro recording. it's already done. I know that i need to supply to method in VB. But how to supply an array to method in ABAP??? There are internal tables in ABAP only and no arrays.