Run Macro

Object to run VBA macros.

Settings

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

Example

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.