Private Sub Workbook_BeforeClose(Cancel as Boolean)
Call backup
End Sub
Sub backup()
Dim chemin As String
Dim fichier As string
Dim strdate = Format(Date, 'dd-mm-yy') & Format(Time, 'h-mm-ss')
fichier = 'MagasinWashroom'
chemin = 'A:\\'
ActiveWorbook.SaveCopyAs chemin + fichier + strdate = '.xls'
End Sub