Sub mlkm()
Set WF = WorksheetFunction
fichier = ThisWorkbook.Name
feuille = ActiveSheet.Name
Set O = Workbooks(fichier).Sheets(feuille)
chemin = ThisWorkbook.Path & "\" & Range("c2") & "\"
fic = Dir(chemin & "*" & Range("c3") & "*")
Workbooks.Open (chemin & fic)
sh = ActiveSheet.Name
Set P = Workbooks(fic).Sheets(sh)
For i = 1 To 9
O.Range("c8").Offset(i, 0) = WF.CountIf(P.Range("d:d"), O.Range("b8").Offset(i, 0))
Next i
Workbooks(fic).Close False
End Sub