topic Re: ole in Application Development and Automation Discussions

ole

Former Member — Mon, 09 Jul 2007 06:04:39 GMT

This is the first time i am using ole.How do i use the functions.what is actually ole application and what are the fuctions which are called using the handler?how is it that the word file accessed???

Please do help me out.Thanks in advance

Re: ole

Former Member — Mon, 09 Jul 2007 06:06:53 GMT

Hi,

Check this 1.

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

Reward if useful!

Re: ole

Former Member — Mon, 09 Jul 2007 06:24:22 GMT

Hi,

Through its Open Object Interface, ABAP supports the OLE2 Automation technique. Desktop applications that provide their functionality in the form of an OLE2 Automation Server (such as Excel or WinWord) can be thus be integrated into R/3.

All applications controlled by ABAP must be registered in R/3.

The following ABAP key words control the applications:

CREATE OBJECT

SET PROPERTY

GET PROPERTY

CALL METHOD

FREE OBJECT

When called from an ABAP program, the SAPGUI acts as OLE client, and the desktop application as the OLE server.

while working with ole, you must include OLE2iNCL program and define each object of type OLE2_OBJECT

for more information follow these links.

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

sample program on excel

http://help.sap.com/saphelp_46c/helpdata/en/72/90fd343603c95ee10000009b38f844/frameset.htm

regards,

Ashok Reddy

Re: ole

Former Member — Mon, 09 Jul 2007 06:49:48 GMT

how do i get to know what are the functions available for the application used?

Re: ole

Former Member — Mon, 09 Jul 2007 07:00:53 GMT

Go to Se38 . In Menu ENVIRONMENT~~>EXAMPLES~~>CONTROLs EXAMPLES..

You will get some of the examples of OLE Examples.

some ex: are as follows..

in Se38 check these

1. SAPRDEMODOCUMENTCONTAINER

2.RSDEMO01

3. RSOLETT1.

Reward if usefull..

Re: ole

Former Member — Mon, 09 Jul 2007 08:51:46 GMT

my requirement is that there is a word document,where there is a value as &word& and this should be replaced by the value passed from sap.Is this possible.If possible how,Could you please give the code.this is done using ole

Re: ole

Former Member — Tue, 14 Aug 2007 09:47:38 GMT

hi nisha,

I am alos having the same requirement.

Can you plz send me a sample code @ doshivinod@gmail.com.

I will be gr8 help for me.

Re: ole

former_member189059 — Sat, 25 Aug 2007 06:32:21 GMT


* word declarations
  DATA: WORD             TYPE OLE2_OBJECT.
  DATA: DOCUMENTS        TYPE OLE2_OBJECT.
  DATA: ACTDOC           TYPE OLE2_OBJECT.
  DATA: SELECTION        TYPE OLE2_OBJECT.
  DATA: FIND             TYPE OLE2_OBJECT.

  CREATE OBJECT WORD 'WORD.APPLICATION' .
  IF SY-SUBRC NE 0 .
    MESSAGE S000(SU) WITH 'Error while creating OLE object!'.
    LEAVE PROGRAM .
  ENDIF .

*--setting object's visibility property
  SET PROPERTY OF WORD 'visible' = '1' .

  GET PROPERTY OF WORD 'documents' = DOCUMENTS.
  CALL METHOD OF DOCUMENTS 'Open'
    EXPORTING
      #1 = 'C:file.doc'. " your current doc

*--Getting active document handle
  GET PROPERTY OF WORD 'activedocument' = ACTDOC .

*--Getting applications handle
  GET PROPERTY OF ACTDOC 'application' = APPLICATION .
  GET PROPERTY OF APPLICATION 'Selection' = SELECTION.

* find
  GET PROPERTY OF SELECTION 'find' = FIND.
  SET PROPERTY OF FIND 'Text' = '&word&'.

  do 10 times.
    CALL METHOD OF FIND 'Execute'.

    CALL METHOD OF selection 'TypeText'
      EXPORTING
      #1 = 'some value'.
  enddo.