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]
|