See this article for multiple methods. 2nd method is using DIR
http://support.microsoft.com/kb/185476/EN-US/
How To Search Directories to Find or List Files
http://support.microsoft.com/kb/185601/EN-US/
HOW TO: Recursively Search Directories by Using FileSystemObject
http://support.microsoft.com/kb/186118/EN-US/
How To Use FileSystemObject with Visual Basic
--
Regards,
Tom Ogilvy
"Emily Edgington" wrote in
message ...
I am trying to use the Dir function to loop through folders in specified
directories, and again to loop through the files in those folders, but my
second Dir is messing with the first one ("RecFile = Dir" in inner loop
makes
"Folder=Dir" in outer loop no longer work).
I have tried putting the inner loop in it's own procedure and calling it
within the outer loop, to no avail. Any suggestions?
Dim FolderPath As String
Dim Folder As String
Dim RecFile As String
Public Sub Create_File_List()
Folder = Dir(FolderPath, vbDirectory)
Do While Folder < ""
If Folder < "." And Folder < ".." Then
If (GetAttr(FolderPath & Folder) And vbDirectory) = vbDirectory
Then
RecFile = Dir(FolderPath & Folder & "\*-pt.xls")
Do Until RecFile = ""
'insert some formulas, yadda yadda yadda
RecFile = Dir
Loop
End If
End If
Folder = Dir
Loop
End Sub