OLE Automation with Excel

[former_member445996]

Hi All,

Does anyone know of any reference/help/material on how to use OLE automation to download and format data from ABAP to Excel.

I need to know what the available methods and properties are so I could format the data the way I want.

Any help will be greatly appreciated.

Regards.

[former_member182670]

Hi

You can find information on this topic at following sites:

OLE integration in ABAP:

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/technologies/an easy reference for ole automation.article

Complete Excel Object Model Reference:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaxl11/html/Welcome_HV01134775.asp

Yoy can also press 'Alt + F11' in Excel and then 'F2' to get to Object Browser. You have there list of all objects/methods/properties an you can always press 'F1' on any of them to see detailed help

[former_member445996]

Thanks for the response. I actually needed to know what methods and properties of excel object are available that we can call ABAP and also how to call them.

Thanks

[ssimsekler]

Hi Aurang

You can call almost all methods using OLE. What is required is to know how to interpret a script to ABAP OLE call. This is explained in 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>

[jayanthi_jayaraman]

Hi,

Check these links for sample program.

http://www.sapgenie.com/abap/code/chap2801.txt

http://www.sap-img.com/ab018.htm