Thread: [Solved] list of Opened excel files
View Single Post
 
Old 05-10-2018, 02:49 PM
goose0701 goose0701 is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Feb 2018
Posts: 4
goose0701 is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Possible misdirection there - the userform code you posted cannot create a new Excel session. That said, in Excel it's possible to have more than one session running. If that's the situation on your system, the code will only find files open in the Excel session it attaches to (probably the last one started). If you open the Task Manager, you should be able to see how many Excel sessions you have running.
ahhhh!! that is exactly it. I have them running in separate instances always.

Is there a way around this to show all excel instances?
Reply With Quote