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
| Option Explicit
Private Function ExistenceFichier(sFichier As String) As Boolean
ExistenceFichier = Dir$(sFichier) <> ""
End Function
Sub presence()
Dim i As Integer
Dim oRng As Range
Dim oChem As String
oChem = "C:\Users\...\Desktop\test"
With Worksheets("Feuil1")
Set oRng = .Range("C5")
For i = 0 To .Cells(Rows.Count, oRng.Column).End(xlUp).Row - oRng.Row
'Si en G5 tu n'as pas les extensions (les ".xls")
If ExistenceFichier(oChem & "\" & oRng.Offset(i, 0) & "*") Then
'If ExistenceFichier(oChem & "\" & oRng.Offset(i, 0)) Then
oRng.Offset(i, 4) = "oui"
Else
oRng.Offset(i, 4) = ""
End If
Next i
End With
End Sub |
Partager