1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| Dim FileNameXls As Variant, i As Integer, wb As Workbook, x As Integer
FileNameXls = Application.GetOpenFilename(filefilter:="Excel Files, *.xl*", MultiSelect:=True)
If Not IsArray(FileNameXls) Then Exit Sub
Application.ScreenUpdating = False
x = 13 'Pour commencer à copier à partir de la cellule D13
For i = LBound(FileNameXls) To UBound(FileNameXls)
Set wb = Workbooks.Open(FileNameXls(i))
wb.Sheets("Cover Page CAA").Range("F12").Copy 'Cellules à copier dans les classeurs
Workbooks("test_list2.xls").Sheets("Listes_Devis").Range("D" & x).PasteSpecial
x = x + 1
Application.CutCopyMode = False
wb.Close SaveChanges:=False
Next i
Application.ScreenUpdating = True |
Partager