Get Open Workbooks
Activity lists all open Excel files.
NOTE: Files opened from cloud storage (OneDrive, Teams etc) won’t be detected.
Activity returns Array of <String> (System.String[]), in the form of full directory path to opened file.
Optional parameter ‘Search Pattern’ allows for narrowing down the search result.
| Parameter Name | Parameter Type | In/Out | Description |
|---|---|---|---|
| Alternative Scenario If Failed | Boolean | Input | checkbox; default is "on" |
| Display Name | Literal | Input | changes display name of the activity |
| Exclude from Transaction Check | Boolean | Input | checkbox; default is "off" |
| Pattern | String | Input | lookup criteria: full file name, or part of it to narrow down the results |
| File List | String | Output | array of full directory paths to opened Excel files |
| 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 it will return 1, the extended result code will show only in several chosen activities |