1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
| Sub Execution()
Dim chemin As String
Dim MyDate As String
Dim sNomfichier As String
Dim Wkb As Workbook, WshDep As Worksheet
Dim Rng As Range
MyDate = Format(Now(), "dd-mm-yy")
chemin = ActiveWorkbook.Path
Set Wkb = Workbooks.Add
Set WshDep = ThisWorkbook.Worksheets(1)
Set Rng = WshDep.UsedRange
Rng.Copy Wkb.Worksheets(1).Range("A1")
sNomfichier = RenommerFichier(chemin, "Synthèse carnet" & "-" & MyDate & ".xlsb")
Wkb.SaveAs Filename:=sNomfichier, FileFormat:=xlExcel12
Wkb.Close savechanges:=False
Set Rng = Nothing
Set WshDep = Nothing
Set Wkb = Nothing
End Sub |
Partager