Sub ListeDesFichiers()
Dim I As Long
With Application.FileSearch
.NewSearch
.FileType = msoFileTypeAllFiles
.LookIn = 'C:\\Documents and Settings\\Utilisateur\\Mes documents'
.SearchSubFolders = True
.Execute
With .FoundFiles
For I = 1 To .Count
Range('A1').Offset(I, 0) = .Item(I)
Next I
End With
End With
End Sub