Microsoft Excel

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.

Get Open Workbooks obraz 1
Parameter NameParameter TypeIn/OutDescription
Alternative Scenario If FailedBooleanInputcheckbox; default is "on"
Display NameLiteralInputchanges the name of activity for greater clarity of the scenario
Exclude from Transaction CheckBooleanInputcheckbox; default is "off"
PatternStringInputlookup criteria: full file name, or part of it to narrow down the results
File ListStringOutputarray of full directory paths to opened Excel files
ResultBooleanOutputreturns a Boolean value: True if no error in activity, otherwise it will return False
Result CodeInt32Outputreturns 0 if there is no error in activity, otherwise in most cases will return 1. Extended result codes show only in several activities