Get a File Listing Using VBA

[@janvanantwerp6574]

Tks Dave. It clearifies a lot. Will be tiding up the existing code used in a project using the fso part...

[@DanielPineault]

Glad it was informative and FSO is a solid approach to use.

[@AndrewOwens28]

I have found this extremely helpful Daniel but I have a Question, How would I display a longer list of files In columns on a form, as a listbox just keeps scrolling like a continuous form dose? The only work around I've found is to use a WebBrowser Control with the control Source linked to the directory with the files but It's not what I want. Is this even possible in Access.

[@DanielPineault]

Well, you could use a list box, see: www.devhut.net/vba-list-of-files-in-a-specified-folder-or-directory/ Or another option would be to use the code to push all the files paths and names to a table and bond a continuous form to that table, then you'd have a scrolling list.