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 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66
| Private Sub CommandButton1_Click()
Dim fic1 As String, fic2 As String, fic3 As String, fic4 As String, fic5 As String
fic1 = Application.GetOpenFilename("Excel Files (*.xls), *.xls", , "Donnez le nom du 1er Fichier")
fic2 = Application.GetOpenFilename("Excel Files (*.xls), *.xls", , "Donnez le nom du 2ème Fichier")
fic3 = Application.GetOpenFilename("Excel Files (*.xls), *.xls", , "Donnez le nom du 3ème Fichier")
fic4 = Application.GetOpenFilename("Excel Files (*.xls), *.xls", , "Donnez le nom du 4ème Fichier")
fic5 = Application.GetOpenFilename("Excel Files (*.xls), *.xls", , "Donnez le nom du 5ème Fichier")
Dim plage1 As String
Dim plageso1 As String
Dim n As Integer
Dim ok As Boolean
ok = False
n = 0
Do Until ok = True
If ActiveSheet.Range("D6:E6").Offset(0, n) <> "" Then
n = n + 2
Else
ok = True
End If
Loop
''''''''''''''''''''''''''''''''''''''''''''''''
plage1 = "F4"
''''''''''''''''''''''''''''''''''''''''''''''''
Application.Workbooks.Open (fic1)
ActiveSheet.Range(plage1).Select
Selection.Copy
ActiveWorkbook.Close False
Application.ThisWorkbook.Activate
Range("D101:E101").Offset(0, n).PasteSpecial
Application.Workbooks.Open (fic2)
ActiveSheet.Range(plage1).Select
Selection.Copy
Application.ThisWorkbook.Activate
Range("D102:E102").Offset(0, n).PasteSpecial
Application.Workbooks.Open (fic3)
ActiveSheet.Range(plage1).Select
Selection.Copy
Application.ThisWorkbook.Activate
Range("D103:E103").Offset(0, n).PasteSpecial
Application.Workbooks.Open (fic4)
ActiveSheet.Range(plage1).Select
Selection.Copy
Application.ThisWorkbook.Activate
Range("D104:E104").Offset(0, n).PasteSpecial
Application.Workbooks.Open (fic5)
ActiveSheet.Range(plage1).Select
Selection.Copy
Application.ThisWorkbook.Activate
Range("D105:E105").Offset(0, n).PasteSpecial
''en erreur
Workbooks(fic1).Close
Workbooks(fic2).Close
Workbooks(fic3).Close
Workbooks(fic4).Close
Workbooks(fic5).Close
''
End Sub |
Partager