How to get list of files in a folder

[darkmastergyz]

Is it possible to get a list of all the files in a folder (including all of it's sub folders)? I'd like to get a list of all those files and write a vba script to check to see if they're in my database, and give a list of files not in my db. I'm not sure exactly how to do that.

 

[KeithG]

Yes it is possible. Search the fourm for the FileSystemObject

 

[RuralGuy]

Here's a link from MVP Allen Browne that you might find useful.