Private Sub CommandButton2_Click()
Dim A As Integer
Dim Fs As Object, Files As Object, F As Object
Dim NomDossier As String
Dim Sf As Object, Fx As Object
Dim NomStagiaire As String
ListBox2.Clear
A = 2
Set Fs = CreateObject("Scripting.FileSystemObject")
NomDossier = "\\squeeze\exo\cours d'anglais\Suivi Stagiaire"
If NomDossier = "" Then Exit Sub
Set Dossier = Fs.GetFolder(NomDossier)
Set Files = Dossier.Files
If Files.Count <> 0 Then
Set F = Fs.GetFolder(NomDossier)
Set Sf = F.SubFolders
For Each Fx In Sf
A = A + 1
ListBox2.AddItem Fx.Name
Next
End If
End Sub
Private Sub ListBox2_Click()
Dim NomStagiaire As String
NomStagiaire = ListBox2.Value
fichiers = Dir("\\squeeze\exo\cours d'anglais\Suivi Stagiaire\" & NomStagiaire & "\")
ListBox1.Clear
Do While fichiers <> ""
ListBox1.AddItem fichiers
'I//écriture du tableau
'A)Le nom du stagiaire
Range("D3").Value = NomStagiaire
'B)Se Présenter
Range("E6").Value = IIf(fichier Like "*ValideSePresenter1*", "X", "")
Range("F6").Value = IIf(fichier Like "*EnCoursSePresenter1*", "X", "")
Range("E7").Value = IIf(fichier Like "*ValideSePresenter2*", "X", "")
Range("F7").Value = IIf(fichier Like "*EnCoursSePresenter2*", "X", "")
'C)Les Articles
Range("E8").Value = IIf(fichier Like "*ValideLesArticles1*", "X", "")
Range("F8").Value = IIf(fichier Like "*EnCoursLesArticles1*", "X", "")
Range("E9").Value = IIf(fichier Like "*ValideLesArticles2*", "X", "")
Range("F9").Value = IIf(fichier Like "*EnCoursLesArticles2*", "X", "")
Range("E10").Value = IIf(fichier Like "*ValideLesArticles3*", "X", "")
Range("F10").Value = IIf(fichier Like "*EnCoursLesArticles3*", "X", "")
fichiers = Dir()
Loop
End Sub