Open Excel File
Activity opens an 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).
Check Excel Invisible (default: off) to open the file as a hidden process (visible via the Task Manager).
NOTE: You can’t have Excel files in two different states during one Wizlink session - all files are visible or all are invisible.
Check Display Alerts (default is off/False) to suppress prompts and alert messages while a macro is running. If the message requires a response, the default one will be chosen (eg. 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).
| Name | Type | Category | Description |
|---|---|---|---|
| Display Alerts | Boolean | Input | checkbox; default is "off" |
| Excel Invisible | Boolean | Input | checkbox; default is "off" |
| File Path | String | Input | directory path to a file (file name and extension included) |
| Retry Timeout [s] | Double | Input | determines 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 Name | String | Input | custom internal name Wizlink will use to identify the workbook |
| Alternative Scenario If Failed | Boolean | Misc | checkbox; default is "on" |
| Display Name | Literal | Misc | changes display name of the activity |
| Exclude from Transaction Check | Boolean | Misc | checkbox; default is "off" |
| Result | Boolean | Output | returns a Boolean value. True if no error in activity, otherwise will return False |
| Result Code | Int32 | Output | Result 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 |
| Fullscreen | Boolean | Screenshot | checkbox; default is "off" |
| Screenshot Path | String | Screenshot | directory path to save location |
| Show Cursor | Boolean | Screenshot | checkbox; default is "off" |
| Window Screenshots | Boolean | Screenshot | checkbox; default is "off" |