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 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85
|
Sub importer()
'
' importer Macro
' Macro enregistrée le 06/04/2010 par Stephane
'
'
Workbooks.Open Filename:= _
"C:\Documents and Settings\mondoc1.xls"
Workbooks.Open Filename:= _
"C:\Documents and Settings\mondoc2.xls"
Workbooks.Open Filename:= _
"C:\Documents and Settings\mondoc3.xls"
Workbooks.Open Filename:= _
"C:\Documents and Settings\mondoc4.xls"
Workbooks.Open Filename:= _
"C:\Documents and Settings\mondoc5.xls"
Workbooks.Open Filename:= _
"C:\Documents and Settings\mondoc6.xls"
Windows("mondoc1.xls").Activate
Range("A1").Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Windows("analyse_resultats3.xls").Activate
Range("A1").Select
ActiveSheet.Paste
Windows("mondoc2.xls").Activate
Range("A1").Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select
Application.CutCopyMode = False
Selection.Copy
Windows("analyse_resultats3.xls").Activate
Sheets("donnees2").Select
Range("A1").Select
ActiveSheet.Paste
Windows("mondoc3.xls").Activate
Range("A1").Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select
Application.CutCopyMode = False
Selection.Copy
Windows("analyse_resultats3.xls").Activate
Sheets("donnees3").Select
Range("A1").Select
ActiveSheet.Paste
Windows("mondoc4.xls").Activate
Range("A1").Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select
Application.CutCopyMode = False
Selection.Copy
Windows("analyse_resultats3.xls").Activate
Sheets("donnees4").Select
Range("A1").Select
ActiveSheet.Paste
Windows("mondoc5.xls.xls").Activate
Range("A1").Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select
Application.CutCopyMode = False
Selection.Copy
Windows("analyse_resultats3.xls").Activate
Sheets("donnees5").Select
Range("A1").Select
ActiveSheet.Paste
Windows("mondoc6.xls").Activate
Range("A1").Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select
Application.CutCopyMode = False
Selection.Copy
Windows("analyse_resultats3.xls").Activate
Sheets("donnees6").Select
Range("A1").Select
ActiveSheet.Paste
End Sub |
Partager