list of Opened excel files

macropod · #1 05-10-2018, 02:25 PM

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.

goose0701 · #2 05-10-2018, 02:49 PM

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?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
seach an Excel list elements in word document	7ajar	Word VBA	5	03-16-2011 12:38 PM
Importing many vcf files in excel	shiflerg	Excel	0	01-26-2011 09:16 AM
Creating mailing labels from list in excel	wordnoob2	Mail Merge	0	12-13-2010 03:46 PM
Opening multiple Excel files within the same Excel window.	lost9471	Excel	2	05-01-2010 01:57 PM
Creating a Distrubution List from Excel	webphotogeek	Outlook	0	01-10-2008 11:21 AM