Run macro Version 9 (Net)

Action group: Excel 

Description

The action runs the macro.

Action icon

Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextAction context for working with an Excel documentRobin.ExcelExcel contextYes
Macro nameThe name of the macro that will be runRobin.String
Yes

Special conditions of use

None.

Example of use

Tasks

There is an Excel-document "Test.xlsm".

Run a macro to count the number of records on a page. 

Solution

  1. For any actions with a specific Excel-document, you should first open the document, create its unique identifier (Context), so that further actions can be applied to a specific document. Open the document "Test.xlsx".
  2. Run the macro.
  3. Save the document.

Implementation

  1. Assemble a robot scheme with the actions:


  2.  Set the "Open" action parameters (see action description "Open").


  3. Set the "Run macro" action parameters.


  4. Set the "Save" action parameters (see action description "Save").


  5. Run the robot by clicking "Start" in the top panel.

Result

The document contains the result of the macro execution.