topic Re: OLE Automation using ABAP in Application Development and Automation Discussions

OLE Automation using ABAP

former_member445996 — Sun, 03 Jul 2005 06:49:01 GMT

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.

Re: OLE Automation using ABAP

former_member182670 — Sun, 03 Jul 2005 09:02:28 GMT

Sample code in VB is:

Worksheets("Sheet2").Activate

Of course you can call it from ABAP

Re: OLE Automation using ABAP

ssimsekler — Sun, 03 Jul 2005 11:53:44 GMT

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>