list of Opened excel files

[goose0701]

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.