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 display name of the activity
Exclude from Transaction CheckBooleanInputcheckbox; default is "off"
File PathStringInputdirectory path to a file (file name and extension included)
Retry Timeout [s]DoubleInputdetermines behaviour if the activity fails to execute. value < 0: try executing once, 0: try indefinitely; value >0: time in seconds during which the activity repeatedly tries to execute (if time elapses without success then Result = False, end activity)
Workbook NameStringInputcustom internal name Wizlink will use to identify the workbook
ResultBooleanOutputreturns a Boolean value. True if no error in activity, otherwise 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