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
| Dim STAT As Workbook
Dim TEST As Workbook
Dim F1 As Worksheet
Dim F2 As Worksheet
Dim derligne As Integer
Dim derlign As Integer
ChDir "C:\Users\mega-pc\Desktop\MACROS EXCEL"
Set STAT = Workbooks.Open(Filename:= _
"C:\Users\mega-pc\Desktop\MACROS EXCEL\STAT BBE.xlsx") 'mettre le nom correct du classeur
Set F1 = STAT.Worksheets("Feuil1")
Set TEST = ThisWorkbook
Set F2 = TEST.Worksheets("Feuil1")
derligne = F1.Range("B65536").End(xlUp).Row
F1.Range("B" & derligne - 3 & ":V" & derligne).Copy
F1.Range("B" & derligne + 1).PasteSpecial
F1.Range("B" & derligne - 3 & ":B" & derligne).Value = Date
derlign = F2.Range("B65536").End(xlUp).Row
F2.Range("B" & derlign - 3 & ":C" & derlign).Copy
F1.Range("E" & derligne + 1).PasteSpecial
F2.Range("D" & derlign - 3 & ":E" & derlign).Copy
F1.Range("H" & derligne + 1).PasteSpecial
F2.Range("F" & derlign - 3 & ":G" & derlign).Copy
F1.Range("K" & derligne + 1).PasteSpecial
F2.Range("H" & derlign - 3 & ":I" & derlign).Copy
F1.Range("N" & derligne + 1).PasteSpecial
F2.Range("J" & derlign - 3 & ":K" & derlign).Copy
F1.Range("Q" & derligne + 1).PasteSpecial
F2.Range("L" & derlign - 3 & ":M" & derlign).Copy
F1.Range("T" & derligne + 1).PasteSpecial
STAT.Save
ActiveWindow.Close
Set TEST = Nothing
Set STAT = Nothing
Set F1 = Nothing
Set F2 = Nothing |