Regarding OLE concept.

[Former Member]

Hi,

I am using OLE for the first time ,

Can any one just help me out in understanding,

Presntly I am working with excel,

I am unable to understand the follwoing things,

CREATE OBJECT EXCEL

SET PROPERTY OF EXCEL

CALL METHOD OF EXCEL

CALL METHOD OF WSHEET

SET PROPERTY OF CELL

Please let me know regarding this matter.

Thanks in Advance,

Irfan Hussain

[Former Member]

Hi,

look into this.

http://www.consolut.de/saphelp/english/Bcfesde6/BCFESDE6.pdf

Thanks.

[Former Member]

IRFAN,

Sample Program: RSDEMO01

Thanks

Kam

Note: Allot points for all worthful postings

[Former Member]

Please refer following links for the information you are looking for

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

http://help.sap.com/saphelp_erp2004/helpdata/en/4f/9937f1446d11d189700000e8322d00/frameset.htm

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/c1d54348-0601-0010-3e98-bd2...

Cheers

Raghava

[jayanthi_jayaraman]

Hi,

Check this link.

An easy reference for ole automation.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/c1d54348-0601-0010-3e98-bd2...

In Excel->Tool->Macro->Visual Basic Editor->F2(object Browser)->choose excel in first box and in second box select the class or method u want.

You can get a hyperlink of the method.This will describe the properties.

Kindly reward points by clikcing the star on the left of reply,if it helps.

[jayanthi_jayaraman]

Hi,

Check these links for more info.

http://www.sapgenie.com/abap/ole.htm

http://help.sap.com/saphelp_46c/helpdata/en/59/ae3f2e488f11d189490000e829fbbd/frameset.htm

[Former Member]

Hi IRFAN HUSSAIN

Visit this link:

-

---

http://help.sap.com/saphelp_erp2005/helpdata/en/59/ae3de5488f11d189490000e829fbbd/frameset.htm

-

---

It should clear all your Doubts regarding:

CREATE OBJECT

SET PROPERTY

GET PROPERTY

CALL METHOD

And look inside the code of Sample Program: RSDEMO01 for sample code.

Cheers,

Vijay Raheja

Message was edited by: Vijay Raheja