Sub test()
Dim Temp, Ext As String
Temp = Split(Selection, ".")
If UBound(Temp) > 0 Then
Ext = Temp(UBound(Temp))
ReDim Preserve Temp(UBound(Temp) - 1)
MsgBox Join(Temp, ".") & " " & Format(Now(), "dd-mm-yy") & "." & Ext
Else
MsgBox "Pas d'extension !", vbCritical + vbOKOnly, "ATTENTION !"
End If
End Sub