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 26 27 28 29 30 31 32 33 34 35 36
| Sub SauveAuto()
Dim chemin As String
Dim Nomfichier As String
Dim DateDevis As String
Dim Indice As String
DateDevis = Format(Now(), "dd-mm-yy")
chemin = ActiveWorkbook.Path
Sheets("DevisClientPLCHetACIERS").Select
Range("A1:J71").Select
Range("J71").Activate
Nomfichier = Sheets("DevisClientPLCHetACIERS").Range("I1")
Indice = Sheets("DevisClientPLCHetACIERS").Range("I2")
Selection.Copy
Workbooks.Open Filename:=chemin & "\Classeur1"
Selection.PasteSpecial Paste:=xlPasteColumnWidths, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
ActiveWindow.SmallScroll Down:=-36
Application.CutCopyMode = False
ActiveWorkbook.SaveAs Filename:=chemin & "\Devis\DevisPlancher_" & Nomfichier & "_" & Indice & "_" & DateDevis, FileFormat:=xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, CreateBackup:=False
ActiveWindow.Close
Range("H72").Select
ActiveWindow.SmallScroll Down:=-63
Sheets("Accueil").Select
End Sub |
Partager