Excel Macro

The Excel Macro action runs a macro in an Excel workbook.

Note: The Actions Quick Reference provides a complete list of actions that you can print for easy reference.

Creating an Excel Macro Action

1. Drag and drop the Target Selector onto the Targets list in the target workbook to display the available target options.

2. Continue to drag the Target Selector to the Workbook option. As an alternative, target the Select All button.

   Note: The Select All button in an Excel workbook is located in the top-left corner (just left of the Column A column header, and just above the Row 1 row header).

   If this is the first time the workbook was targeted, Nintex RPA LE will attempt to create a workbook connection automatically. For more information about Microsoft Excel workbook connections, see Excel Connections.

3. Select the Excel Macro action from the Actions list in the preview window.

4. Click Rules to change the connection for this action.

5. Configure the Timing  and Error settings for this action to fine tune the how the action will run.

   Note: For more information about the timing and error settings, go to Action Builder.

6. Enter the Macro name you want to run.  

7. (Optional) Add Notes to the action to document any special instructions or functionality.

8. Click OK to save the action.

   If the run wwitchis set to Run, the action will be executed.

   Note: The run switch is set to Run by default. To create or modify this action without executing it, click the slider to change the option to Don't Run.  For more information, go to Action Builder.