|
|
#7
02-23-2018, 01:33 PM
|
||||
|
||||
As I said, the code works for me and lists multiple files. No Excel reference is needed, as late binding is used. Perhaps the issue is that your userform has already created its own Excel session and is therefore only finding files running under that session?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
| Thread Tools | |
| Display Modes | |
|
|
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