Finding file names in a directory

I have a known directory with an unknown number of files. How can I go about finding each file in the directory and then copying their name into the workbook?

What I'm hoping to do is have a "template folder" then when the user brings up a userform, the userform will check what files are in the template folder and use those names to create an excel name to populate a combobox.

*Bonus points* How do I search for only a type of file (such as .doc)?

Hello Wilro85,

It easy to do using the FSO (FileSystemObject).

Please Login or Register  to view this content.

Sincerely,
Leith Ross