Sub test()
Dim Chemin As String
Application.DisplayAlerts = True
Chemin = "C:\Users\xxxxx\Desktop\" 'chemin à adapter
ActiveWorkbook.SaveAs Filename:= _
Chemin & "Test - " & Format(Date, "yyyy mm dd") & " - planning", FileFormat:=xlExcel8, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False
Application.DisplayAlerts = False
End Sub