HOW TO CREATE AN LINEGROUP ON OLE

[former_member2755]

dear all：

           I would like to ask you a question about the OLE,

           I use grammar  ：CALL METHOD OF range 'GROUP'.

           this  is  column grouping

           HOW TO CREATE AN LINEGROUP ON OLE

           think you verymuch~

            

[raymond_giuseppi]

First step should be recording of a macro in Excel. Then analyze the generated macro source and translate it to Abap/OLE2.

Regards,

Raymond

[former_member2755]

thank you  very much！but excel  macro is 

    Range("A4:B6").Select

    Selection.Rows.Group

I refer to table OLELOAD find field  GROUP

I try it and Answer this is right。

CALL METHOD OF range 'GROUP'

         EXPORTING

         #1 = '1'.

       m_message.

But I don't really understand the relationship between it.

please tell me how can i analyze the grammar。

think you very much。

[raymond_giuseppi]

There is a document describing this method (VBA Macro to Abap) Copying data from Microsoft Excel to ABAP using OLE.

Regards,

Raymond

[former_member2755]

Thank you very much for your help.