Access VBA ways to obtain file system directory listing

[mdlueck]

Greetings,

I am seeking examples of Access VBA (running in MSO 365 Build 16.0.x 32-bit) of how to obtain file system directory listings.

Seems Application.FileSearch is now deprecated / removed. I have heard of using some Microsoft Office Object solution. There might be others that come with standard MS Office. Please kindly advise.

If there is need to utilize an add-on versus native VBA code, then I would like to include the constants in a VBA Include file and use Late-Binding rather than require an add-on be checked within each instance of Access being utilized.

I am thankful,

 

[theDBguy]

If you're looking for a way to list the files in a directory/folder, then have a look here.

List Files in a Folder and its Subfolders

While trying to answer a question in the MSDN Forums, I realized although there are already a lot of examples on how to list all the files i...

thedbguy.blogspot.com

 

[The_Doc_Man]

It would take a bit of studying, but there is always the "FileSystemObject" (written with no spaces when being referenced as an object). It comes from the Windows Scripting Library.

FileSystemObject object

Office VBA reference topic

learn.microsoft.com

Browse around with that reference as your starting point. You can get a file (as an object), explore folders via their collection of files, get file properties... great fun.