Thread: [Solved] list of Opened excel files
View Single Post
 
Old 05-10-2018, 02:16 PM
goose0701 goose0701 is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Feb 2018
Posts: 4
goose0701 is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
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.
Reply With Quote