I have a big folder which contants a lot of doc files, whose has some stable
name rule.

To make a filter to those file, I'd like to prepare a list which contains
all of the file name in this folder.

I am able to use VBA, but have no idea which function to use. Could help me?

What's more, if the function could search via subfolder, that will be better.

Thanks!