B Brad Apr 17, 2010 #1 Is it possible to obtain a list of all files in one sub-directory with Access 2007 VBA code? Brad
S Stuart McCall Apr 18, 2010 #2 Brad said: Is it possible to obtain a list of all files in one sub-directory with Access 2007 VBA code? Brad Click to expand... 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 said: Is it possible to obtain a list of all files in one sub-directory with Access 2007 VBA code? Brad Click to expand... 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.