Sheets("Fiche Incident").Select
n = Right([G2], 1) + 1
k = Right([G2], 2): k = Left(k, 1)
If n = 10 Then
n = 1
k = Split(Range(k & "1").Offset(, 1).Address, "$")(1)
End If
If k = "AA" Then k = "A": n = 1
[G2] = "XXX" & Format(Date, "dd-mm-yy") & k & n
chemin = ThisWorkbook.Path & "\"
Sheets("Fiche Incident").Copy
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs Filename:=chemin & [G2] & ".xls"
Application.DisplayAlerts = True
ActiveWorkbook.Close