Microsoft Excel

Run Macro

Fill the WorkbookName position with custom internal name of your Excel file. Enter a name of the macro. Specify how long Wizlink will wait for the macro to finish (set the time in seconds in Max Execution Time parameter). If macro doesn't complete the action in given time - the activity will return False.

Activity does not provide for handling macro-triggered windows - the appearing window will stop the activity and set Result to False.

Parameter NameParameter TypeIn/OutDescription
Alternative Scenario If FailedBooleanInputcheckbox; default is "on"
Display NameLiteralInputyou can change the name of activity for greater clarity of the scenario
Exclude from Transaction CheckBooleanInputcheckbox; default is "off"
Macro nameStringInputmacro name
Max Execution TimeDoubleInputmaximum execution time; if exceeded, activity assumed to fail
Workbook NameStringInputcustom internal name for Excel file, in order to identify Excel workbook in Wizlink
ResultBooleanOutputreturns the Boolean value: it will return True if no error is in activity, otherwise it will return False
Result CodeInt32OutputResult Code will return 0 if there is no error in activity, otherwise in most cases it will return 1, the extended result code will show only in several chosen activities