Option Explicit
Dim Fichier As String
Sub Back_Up_3()
Application.ScreenUpdating = False
Sheets("BD").Select
Range("Tablo_2").Copy
' Supprimer les slash de la date sinon = ERREUR
Fichier = Format(Range("A1"), "dd_mm_yyyy_hh_mm")
Workbooks.Add
ActiveSheet.Paste
Application.CutCopyMode = False
ActiveWorkbook.SaveAs Filename:="C:\Back_up\" & Fichier & "_Mon_Nom.csv", FileFormat:=xlCSV, CreateBackup:=False
ActiveWorkbook.Close False
Application.ScreenUpdating = True
End Sub