1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
| Private Sub CommandButton4_Click()
Dim Fs As FileSearch
Dim Dossier As String
Dim I As Integer
On Error Resume Next
ListBox1.Clear
Set Fs = Application.FileSearch
Dossier = "C:\Blabla\" & ComboBox1
With Fs
.NewSearch
.Filename = "*.*"
.LookIn = Dossier
.SearchSubFolders = False
.Execute msoSortByFileName, msoSortOrderAscending
If .Execute > 0 Then
With .FoundFiles
For I = 1 To .Count
Me.ListBox1.AddItem Dir(.Item(I))
Next I
End With
Else
MsgBox "Aucun classeur trouvés " & _
"dans le dossier '" & Dossier & "'."
Me.ListBox1.AddItem "Aucun classeur !"
End If
End With
Set Fs = Nothing
End Sub |
Partager