...e_014...


List files from a folder
Sub Search_files()
 Dim FileS As FileSearch
 Dim F As Variant
 Dim x As Integer
 Set FileS = Application.FileSearch
   With FileS
      .NewSearch
      .Filename = InputBox("Insert file name")
      .LookIn = InputBox("Insert the path")
      .SearchSubFolders = True
      .Execute
   End With
 x = 1
   For Each F In Application.FileSearch.FoundFiles
      Cells(x, 1) = F
      x = x + 1
   Next F
End Sub

by Bert Körn