Run Macro
Object to run VBA macros.
Last updated
Object to run VBA macros.
Last updated
This object depends on the use of the "New Excel" or "Open Excel" objects to work.
Run Macro: Execute an already existing macro Note: .xlsm format is required
Field
Descriptive
Title
Object Title
Select Main Object
Option to select an Excel sheet
Macro Name
Macro Name
Select Cells
Select cells for macro execution
Starting Cell
Initial cell of the selection
Final Cell
Final selection cell
To execute a macro on an Excel file sheet it is necessary to have an pre-existing file and follow the next steps
1 - Select the "Open Excel" object from the "Excel" menu and drag it to your working area.
First you must define a unique name for the object in the "Object Identifier Name" field, inform the complete directory containing the name and the extension of the file and then set a password if it is required.
2 - You should then select the "Run Macro" object in the "Excel" menu, choose a unique name for the object in the "Object Identifier Name" field and define the name of the macro.
If you select the "Select Cells" option, you will need to enter the values for the "Starting Cell" and "Final Cell" fields for the macro to run.
