OLE2 Excel

[Former Member]

Hi,

Im looking for a Microsoft Excel OLE2 <u>reference</u>. All I could find on SDN are tutorials. I want to see all available methds and properties. Do you guys know where I could find such?

Thanks in advance!

[Nkrish]

Hi,

go to SE80 and under package write : SOFFICEINTEGRATION

this would give you all the sample programs, with methods for most of the MS-Office products

Regards,

Narayani

[Former Member]

hi,

by using OLE2 concept we can control the execution of external applications like Excel and WIN WORD with ABAP, fopr that we can use few ABAP STATEMENTS like CREATE OBJECT

CALL METHOD

FREE METHOD

SET PROPERTY

GET PROPERTY

for additional information we include one INCLUDE PROGRAM

INCLUDE OLE2INCL.

For brief information u follow the below link.

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCFESDE6/BCFESDE6.pdf

regards,

sudheer.

[Former Member]

hi

good

go through this link which ll give you detail idea about the relation between sap and microsoft excel ole2

http://searchsap.techtarget.com/tip/1,289483,sid21_gci775513,00.html

thanks

mrutyun^

[Former Member]

thx guys.. Great links but I was hoping that I get a full listing of the properties and methods rather than overviews and short examples. In any case, these should suffice for now. Thanks again.

[Former Member]

check with function module - EXCEL_OLE_STANDARD_DAT

[Nkrish]

hi,

the package name that i had given has the sample programs.In those you will find most of the properties and the methods.

you can copy these programs and try out different combinations.

I tried it the same way. Thanks for the points.

Regards,

Narayani

[Nkrish]

Please check this link. You can download the pdf.

it has all the methods.

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCCIOFFI/BCCIOFFI.pdf

regards

Narayani