|
|
#9
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.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
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 |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode