I_OI_DOCUMENT_PROXY->EXECUTE_MACRO in excel

[Former Member]

Hi,

I want to execute a macro to add a chart into excel. I created the macro 'graphic' in excel then I call it from abap with the metod execute macro but it doesn't work.

DATA:  DOCUMENT    TYPE REF TO I_OI_DOCUMENT_PROXY. 

  ... 
  
  CALL METHOD DOCUMENT->EXECUTE_MACRO 
    EXPORTING 
      MACRO_STRING = 'Modulo1.graphic' 
    IMPORTING 
      ERROR        = ERRORS 
      RETCODE      = retcode 

Also I tried

  CALL METHOD DOCUMENT->EXECUTE_MACRO 
    EXPORTING 
      MACRO_STRING = 'graphic' 
    IMPORTING 
      ERROR        = ERRORS 
      RETCODE      = retcode 

I would like you give me instructions for make it work. Do I have to do anything else to make it work?.

[Former Member]

Hi,

I want to execute a macro to add a chart into excel. I created the macro 'graphic' in excel then I call it from abap with the metod execute macro but it doesn't work.

DATA:  DOCUMENT    TYPE REF TO I_OI_DOCUMENT_PROXY. 

  ... 
  
  CALL METHOD DOCUMENT->EXECUTE_MACRO 
    EXPORTING 
      MACRO_STRING = 'Modulo1.graphic' 
    IMPORTING 
      ERROR        = ERRORS 
      RETCODE      = retcode 

Also I tried

  CALL METHOD DOCUMENT->EXECUTE_MACRO 
    EXPORTING 
      MACRO_STRING = 'graphic' 
    IMPORTING 
      ERROR        = ERRORS 
      RETCODE      = retcode 

I would like you give me instructions for make it work. Do I have to do anything else to make it work?.

[Former Member]

Hi,

Please refere thie demo (Pie Chart) program GFW_PROG_PIE. This will help you.

Need more ifn fo please send me an e-mail.

Cheers.

Message was edited by: Lanka Murthy