Microsoft Excel

Open Excel File

Activity opens existing Excel file. Fill in the File Name (entire directory and name of your file, with extension). The activity allows you to define its custom internal name for further use (Workbook Name).

NOTE: there is a checkbox Excel invisible (default is off). When you tick it the activity does open Excel file but without any visible mark on the screen (however, it is visible in the Task Manager: you could right-click on the Windows taskbar and select Task Manager to see a list of currently running applications). You can’t have Excel files in two different states during one Wizlink session - all files are visible or all are invisible.

NOTE: there is a checkbox Display alerts (default is off/False). It suppresses prompts and alert messages while a macro is running, and when a message requires a response, Microsoft Excel chooses the default response (in particular: when Display alerts is set to False and macro asks whether to save the file, the default response is Yes; this overwrites the existing file).

v2_ex_open
Acquired TextStringOutputtext input by user
Alternative Scenario If FailedBooleanInputcheckbox; default is "on"
Display AlertsBooleanInputcheckbox; default is "off"
Display NameLiteralInputchanges display name of the activity
Excel InvisibleBooleanInputcheckbox; default is "off"
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 will return 1. See the table of Extended Result Codes for more info