Microsoft Excel

Attach Open Excel

Activity allows Wizlink to take control of an already open Excel file.

Activity requires full directory path to the file (File Path) and a custom internal name for further use in Wizlink (Workbook Name). File Path can be acquired using the Get Open Workbooks activity.

NOTE: Display alerts (default: off/False) will suppress prompts and alert messages while a macro is running. When a message requires a response, Microsoft Excel chooses the default response (for example: if the macro asks whether to save the file, the default response is Yes; this will overwrite the existing file).

Attach Open Excel
Parameter NameParameter TypeIn/OutDescription
Alternative Scenario If FailedBooleanInputcheckbox; default is "on"
Display AlertsBooleanInputcheckbox; default is "off"
Display NameLiteralInputchanges the name of activity for greater clarity of the scenario
Exclude from Transaction CheckBooleanInputcheckbox; default is "off"
File PathStringInputfull directory path to a file
Retry timeout [s]DoubleInputdetermines behaviour if the activity fails to execute:
Negative value: tries executing once, on fail – sets Result to False and ends activity;
0: tries execution indefinitely; Positive value: time in seconds during which the activity repeatedly tries to execute. (if success: Result = False, end activity, if time elapses without success - Result = False end activity)
Workbook NameStringInputcustom internal name for the Excel file, in order to identify it in Wizlink
ResultBooleanOutputreturns a Boolean value; True if no error in activity, otherwise it will return False
Result CodeInt32Outputreturns 0 if there is no error in activity, otherwise in most cases will return 1. Extended result codes show only in several activities