Description

Execute the macro inside a workbook. The Workbook file needs to be a Macro-Enabled Workbook.



Properties

Output

  • MacroOutput - The value returned when the macro is executed.

Input

  • MacroName - The name of the macro to be executed.

  • MacroParameters - Enables you to pass parameters when executing the macro. This field supports only IEnumerable<object> variables.

Common

  • ContinueOnError - The Boolean value to specify whether to continue executing the next activities even if there is an error thrown on this activity.

Misc

  • DisplayName - Renames the activity.


Example

  1. Add an Excel Sequence activity inside a Sequence.
  2. In the File Path, search for and select your Spreadsheet document by, first, clicking the browse button.
  3. Add an Execute Macro activity.
  4. In the Macro Name field, type Macro1 (or the name of your own Macro). The use case should look as the following screenshot.



After executing, the Macro inside the specified Spreadsheet document should be executed.