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 (saved files) or just opened file name (freshly opened, unsaved files)
Optional parameter ‘Search Pattern’ allows for narrowing down the search result. Search Pattern has to contain the entire word.
| Acquired Text | String | Output | text input by user |
|---|---|---|---|
| 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 will return 1. See the table of Extended Result Codes for more info |