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
| Sub Prod3()
Sheets("Aoustin").Select
Application.ScreenUpdating = False 'cacher l éxecution de la macro
Dim fic As String
Dim CL1 As Workbook, Chemin
Dim fl As Worksheet
Dim thomas As Worksheet
Dim Lignecopie As Long
Workbooks("sauvegardeOEE2007.xls").Sheets("Aoustin").Range("A2:A65536").ClearContents
Chemin = "T:\Base Services RHODIA Silicones\Elastomeres\Dossier commun avec les Chefs de Poste\OEE 2007\"
fic = Dir(Chemin & "OEE & MAP Aoustin 2007.xls")
Do Until fic = ""
Set CL1 = Workbooks.Open(Chemin & fic)
DoEvents
Set fl = CL1.Worksheets("Saisie")
Set FL2 = Workbooks("sauvegardeOEE2007.xls").Sheets("Aoustin")
FL2.Range("A" & FL2.Range("A65536").End(xlUp).Row + 5).Value = _
fl.Columns("A").Value
fic = Dir
CL1.Close True 'si tu enregistres le fichier ouvert -> Sinon c'est False
DoEvents
Loop
Set CL1 = Nothing
Set fl = Nothing
Application.ScreenUpdating = True
End Sub |