Sub Liste()
Dim strMessage As String
Dim i As Long
Dim fic As String
Dim Wkb As Workbook
Dim ws As Worksheet
Dim nbfic As Long
Dim monchemin As String
Dim achanger As String
Dim par As String
monchemin = [Feuil1!B3]
If Right(monchemin, 1) <> "\" Then monchemin = monchemin & "\"
achanger = [Feuil1!B5]
par = [Feuil1!B7]
fic = Dir(monchemin & "*.xls")
nbfic = 0
Do Until fic = ""
Set Wkb = Workbooks.Open(Filename:=monchemin & fic)
For Each ws In Wkb.Worksheets
ws.Cells.Replace What:=achanger, Replacement:=par, LookAt:=xlPart _
, SearchOrder:=xlByRows, MatchCase:=False
Next ws
Wkb.Close True
fic = Dir
nbfic = nbfic + 1
Loop
If nbfic = 0 Then
MsgBox "Il n'y a aucun fichier."
Else
MsgBox "Il y a " & nbfic & _
" fichier(s) trouvé(s)."
End If
End Sub