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
| Sub Renommer()
Dim I As Long, J As Long, nbLignes As Long
Dim Idx As Long
Dim NomOriginal As String, NouveauNom As String
Dim Chemin As String
Dim Ext As String
Dim Tablo
Chemin = "C:\Users\HM PHOTOGRAPHIE\Desktop\amponville\"
Ext = ".jpg"
nbLignes = Cells(Rows.Count, "A").End(xlUp).Row
Tablo = Range("A1:A" & nbLignes).Value
For I = 1 To UBound(Tablo) - 1
Idx = 0
For J = Tablo(I, 1) To Tablo(I + 1, 1) - 1
Idx = Idx + 1
NomOriginal = Format("0") & Ext
NouveauNom = Range("C" & I) & Idx & Ext
If Dir(Chemin & NomOriginal) <> "" Then
Name Chemin & NomOriginal As Chemin & NouveauNom
End If
Next
Next
End Sub |