Quote:
Originally Posted by macropod
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?