Skip to Content
0
Former Member
Apr 01, 2009 at 04:12 AM

Sap OLE to Excel

18 Views

hi all ,

I am working with organisation chart. i want to insert the org chart in excel. this is my recording in excel

ActiveSheet.OLEObjects.Add(ClassType:="OrgChart", Link:=False, _
      DisplayAsIcon:=False).Activate

For this i have used this following code But it is not working what i have to change in this coding

CALL METHOD OF excel 'WORKBOOKS' = workbooks.

CALL METHOD OF workbooks 'ADD' = workbook.
*CALL METHOD OF excel 'ACTIVESHEET' = activesheet.
GET PROPERTY OF excel 'ACTIVESHEET' = activesheet.

GET PROPERTY OF activesheet 'OLEObjects' = oleobjects.
GET PROPERTY OF oleobjects 'Add' = add.

CALL METHOD OF oleobjects 'Add'
  EXPORTING
  #1 = 'OrgChart'
  #2 = '2'
  #3 = '2' .

CALL METHOD OF oleobjects  'Activate'.

Plz anyone give ur idea to correct it