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

  • Thread starter Thread starter Brad
  • Start date Start date
B

Brad

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

Brad
 
Brad said:
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.
 
Back
Top