Calling an excel macro with parameters from ABAP

Question

How can I call an excel macro with parameters from ABAP? I've found plenty of references for calling a macro without parameters online using the following method:

CALL METHOD OF obj_ex_APP 'Run' 
   EXPORTING #1 = 'Macro_ID'.

But I can't find anywhere how to pass the parameter. Thanks for any pointers.

mydoghasworms · Accepted Answer · 2013-06-13 11:21:42Z

4

The arguments/parameters passed to the Macro are specified in consecutive parameters from ABAP.

So let's say you have a trivial macro like the following:

Sub Macro1(value)
    Range("A1").Select
    ActiveCell.FormulaR1C1 = value
End Sub

Then the corresponding code to call the Macro from ABAP will be

call method of excel 'Run'
  exporting #1 = 'Macro1'
            #2 = 'Wassup'. "<- Argument to the 'value' parameter

The only bump you might hit is that you can pass a maximum of 9 parameters to an OLE call from ABAP (correct me if I am wrong), while the Run method allows you to specify 30 parameters for a Macro, so you are left with 8 parameters you can pass to the macro.

For more info, see http://msdn.microsoft.com/en-us/library/office/ff197132.aspx

answered Jun 13, 2013 at 11:21

mydoghasworms

18.7k11 gold badges65 silver badges100 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Calling an excel macro with parameters from ABAP

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related