n00b1337

Sorry, I was rushing out the door and did not give you a complete view of things. Cut and paste this entire code excert into an empty form. Put a CommandButton and a ListBox on the form, then run the code.
Of course add the FileSystemObject reference to your code (Microsofts Scripting Runtime)

VB Code:
  1. Option Explicit
  2.  
  3. Dim FSys As FileSystemObject
  4.  
  5.  
  6. Sub ScanFolder(FolderSpec)
  7.  
  8. Dim thisFolder As Folder
  9. Dim allFolders As Folders
  10. Dim thisFile As File
  11. Dim allFiles As Files
  12.  
  13. Dim i As Integer
  14.  
  15.    Set thisFolder = FSys.GetFolder(FolderSpec)
  16.    Set allFolders = thisFolder.SubFolders
  17.    
  18.    
  19.    For Each thisFolder In allFolders
  20.    
  21.       List1.AddItem thisFolder.Path   ' Add folder path to the listbox
  22.       Set allFiles = thisFolder.Files
  23.    
  24.       If allFiles.Count > 0 Then
  25.         For Each thisFile In allFiles
  26.            List1.AddItem thisFolder.Path & "\" & thisFile.Name   ' Add folder path and filename to listbox
  27.  
  28.         Next
  29.       End If
  30.      
  31.       Set allFiles = Nothing
  32.      
  33.       ScanFolder thisFolder.Path
  34.       DoEvents
  35.      
  36.    Next
  37.    
  38.    Set thisFolder = Nothing
  39.    Set allFolders = Nothing
  40.    
  41. End Sub
  42.  
  43. Private Sub Command1_Click()
  44.  
  45.    ScanFolder ("c:\")
  46.    MsgBox "ScanFolders Complete"
  47.    
  48. End Sub
  49.  
  50. Private Sub Form_Load()
  51.  
  52.    Set FSys = New FileSystemObject
  53.  
  54. End Sub