list of Opened excel files

macropod · #1 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?

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

Quote:

Originally Posted by macropod

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?

Better late than never. I am sorry I haven't had time to mess with this project lately.

So how would my userform create it's own Excel session? This is the only code I have in the UserForm Initialize sub. So I am unsure where to look.

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