Run Macro Activity
The Run Macro activity enables users to execute a specified macro within an open Excel workbook. This activity streamlines automation by allowing direct invocation of pre-defined Excel VBA macros, enhancing data processing and manipulation capabilities.
| Field | Description | Requirement |
|---|---|---|
| Excel Name | The name of the Excel file that was previously opened or created, where the macro resides. | Required |
| Macro Name | The name of the macro to be executed within the specified Excel file. | Required |
Action Types & Examples
Excel Name
- Format: string
- Example Result: "MyReport.xlsx"
Macro Name
- Format: string
- Example Result: "ProcessData"
Implementation Examples
Field Setup - Excel Name: newExcel - Macro Name: runMacro
Execution Parameters - Activity: Run Macro - Input: Excel Name = newExcel - Input: Macro Name = runMacro
Technical Notes
Ensure that the specified Excel file is already open and accessible within the automation workflow before this activity is executed. The macro name provided must exactly match a macro defined within that Excel workbook, including case sensitivity, to prevent runtime errors.