'Option Explicit
Sub Sauvegarde()
Dim ABC As String, Temp As String, Ret As String, Jour As String, dossier1 As String, sousdossier2 As String, Nom As String, Dossier3 As String, Nom1 As String
Dim Dat As String, Nom3 As String, Utilisateur As String
Dim Cible As Object, Dossier As Object
Dim réponse1
réponse1 = MsgBox("Vous Allez Sauvegarder Votre Fichier ( ATTENTION sauvegarde automatique ! ) ", vbYesNo + vbQuestion, "Validation")
If réponse1 = vbNo Then Exit Sub
Nom = "Sauvegarde"
dossier1 = ThisWorkbook.Path & "\" & Nom
Nom1 = "Temp"
Dossier3 = ThisWorkbook.Path & "\" & Nom1
If Dir(Dossier3, vbDirectory) = "" Then MkDir (Dossier3)
Dat = Format(Sheets("settings").Range("B15"), "DD mmmm yyyy")
Nom3 = Sheets("settings").Range("B16")
Utilisateur = Sheets("settings").Range("B17")
If Dir(dossier1, vbDirectory) = "" Then MkDir (dossier1)
sousdossier2 = ThisWorkbook.Path
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs dossier1 & "\" & Nom3 & " " & Dat & " " & " " & Utilisateur & ".xls"
ActiveWorkbook.SaveAs sousdossier2 & "\Envoi Mail Outlook Express" & ".xls"
ActiveWorkbook.SaveAs Dossier3 & "\" & Nom3 & " " & Dat & " " & " " & Utilisateur & ".xls"
ActiveWorkbook.SaveAs sousdossier2 & "\Envoi Mail Outlook Express" & ".xls"
'Zip_ActiveWorkbook
MsgBox "Sauvegarde Effectuée . ", vbInformation, "Message"
Unload Me
Application.DisplayAlerts = True
End Sub