Hello,
Le code suivant créera ton fichier au format
d-m-yyyy.xls
Ex: 1-4-2016.xls
Sub doublage()
Dim monRepertoire As String, cheminComplet As String
monRepertoire = "Z:\Tour\Archivage\"
Dim maDate As Date
maDate = Sheets("Feuil1").Range("B5")
cheminComplet = monRepertoire & Day(maDate) & "-" & Month(maDate) & "-" & Year(maDate) & ".xls"
ActiveWorkbook.SaveAs Filename:=cheminComplet, FileFormat:=xlExcel8, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, CreateBackup:=False
End Sub