My goal is to get a list of all open Excel 2016 files and prompt the user to select which file they want to choose as the source of the the automation process. The issue i’m having is that only the most recently active excel file shows in the process list. I can have 3 Excel files open (eg. Book1, Book2, Book3) but only the one I select or open last (eg Book3) will show in the process list.
The general steps, I believe:
- Get Processes --> Object collection
- For each item in the object collection, if the application (item.ProcessName) = “Excel” then Add To Collection the window title (item.MainWindowTitle) to a List openExcel.
- Convert the List to an array of strings (openExcel.toArray), to be used as options in an Input dialog
Any ideas why Get Processes might not be pulling everything? Apparently the above process works fine with non MS Office applications. Excel, Word, and Powerpoint do not show all instances. It’s just a guess, but we have the 32-bit version of ms office installed - would that matter?
(I would upload the file but as a new user, apparently i’m not allowed to yet)
edit with screenshots:
(apparently i can only embed 1 picture at a time too, so will reply with new screenshots)
My workflow and variables