1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| If Moisencours = juin Then
moisavant = mai
moisencourslettre = I
moisencourslettre2 = H
End If
'______________________________________________________
Var = ActiveWorkbook.Name
Source = "E:\Automatisation V2\V2 réalisé " & moisencours & ".xls"
Workbooks.Open Source, , True
'----------------------------------------------------------------
Valsource = ActiveWorkbook.Worksheets(1).Range(moisencourslettre & "34")
Valsource = Format(Valsource, "#0.0")
Workbooks(Var).Worksheets("Synthese").Range("B4").Value = Valsource
' --------------------------------------------------------------- |