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 display name of the activity
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 will return False
Result CodeInt32OutputResult 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