topic Re: OLE2 Excel in Application Development and Automation Discussions

OLE2 Excel

Former Member — Wed, 06 Jun 2007 10:10:23 GMT

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!

Re: OLE2 Excel

Nkrish — Wed, 06 Jun 2007 10:39:36 GMT

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

Re: OLE2 Excel

Former Member — Wed, 06 Jun 2007 10:59:50 GMT

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.

Re: OLE2 Excel

Former Member — Wed, 06 Jun 2007 11:21:50 GMT

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^

Re: OLE2 Excel

Former Member — Wed, 06 Jun 2007 16:07:33 GMT

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.

Re: OLE2 Excel

Former Member — Wed, 06 Jun 2007 16:10:48 GMT

check with function module - EXCEL_OLE_STANDARD_DAT

Re: OLE2 Excel

Nkrish — Wed, 06 Jun 2007 16:13:45 GMT

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

Re: OLE2 Excel

Nkrish — Fri, 08 Jun 2007 07:18:35 GMT

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