Obtain a list of all files in one sub-directory with VBA?

[Brad]

Is it possible to obtain a list of all files in one sub-directory with Access
2007 VBA code?

Brad

 

[Stuart McCall]

Is it possible to obtain a list of all files in one sub-directory with
Access
2007 VBA code?

Brad

Dim fdr As String

fdr = Dir("c:\temp\*.*")
Do While fdr <> ""
debug.Print fdr
fdr = Dir
Loop

This will output all the file names contained in c:\temp to the debug
window.

 

[Brad]

Stuart,

Thanks for the help, I really appreciate it.

Brad