OLE Automation using ABAP

[former_member445996]

Hi All,

I have the following Qs.

-- I am using OLE automation to download data to excel. I have two sheets in my workbook. After I am done downloading the data on the first sheet, how can I activate or select the second sheet for displaying the data on that.

-- What are the classes in SAP used for OLE automation. How can I look at them. Is it possible to see them in SE24.

Thanks for your help.

[former_member445996]

Hi All,

I have the following Qs.

-- I am using OLE automation to download data to excel. I have two sheets in my workbook. After I am done downloading the data on the first sheet, how can I activate or select the second sheet for displaying the data on that.

-- What are the classes in SAP used for OLE automation. How can I look at them. Is it possible to see them in SE24.

Thanks for your help.

[former_member182670]

Sample code in VB is:

Worksheets("Sheet2").Activate

Of course you can call it from ABAP

[ssimsekler]

Hi Aurang

You can have a look to the tutorial<a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/c1d54348-0601-0010-3e98-bd2a2dcd9e6c">"An Easy Reference For OLE Automation"</a>

Regards

*--Serdar <a href="https://www.sdn.sap.com:443http://www.sdn.sap.comhttp://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.sdn.businesscard.sdnbusinesscard?u=qbk%2bsag%2bjiw%3d">[ BC ]</a>