Sub CreerFichier()
Dim NewName, x, xSh As Worksheet, Haut As Long, Larg As Long
Dim LastCol As Long, LastRow As Long, xRg As Range
Dim Debut As Currency, Fin As Currency, Freq As Currency
Sheets("Modele").Visible = False
' (.....)
Workbooks.Add
NewName = ActiveWorkbook.Name
'copie des feuilles crées dans classeur origine vers le nouveau classeur
For Each x In Liste_Date
If x <> DateSerial(1999, 9, 9) And Format(x, "dddd dd mmm yyyy") <> Feuil_Liste And _
Format(x, "dddd dd mmm yyyy") <> Feuil_Modele Then
ThisWorkbook.Sheets(Format(x, "dddd dd mmm yyyy")). _
Move before:=ActiveWorkbook.Sheets(1)
End If
Next x
' (.....)