Microsoft Excel

Attach Open Excel

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

Attach Open Excel

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).

NameTypeCategoryDescription
Display AlertsBooleanInputcheckbox; 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
Alternative Scenario If FailedBooleanMisccheckbox; default is "on"
Display NameLiteralMiscchanges display name of the activity
Exclude from Transaction CheckBooleanMisccheckbox; default is "off"
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 will return 1. See the table of Extended Result Codes for more info
FullscreenBooleanScreenshotcheckbox; default is "off"
Screenshot PathStringScreenshotdirectory path to save location
Show CursorBooleanScreenshotcheckbox; default is "off"
Window ScreenshotsBooleanScreenshotcheckbox; default is "off"