Sub new_file()
Dim sDate$, sFichier$, sChoix$
Dim i%
chemin00 = "C:\Users\...\Desktop\la macro\07. Informations DOCS"
chemin01 = "C:\Users\...\la macro\03. FICHIER SORTIE"
sDate = Cells(13, 3)
sFichier = Cells(10, 3)
sChoix = Cells(4, 3)
For i = 21 To 41
If sChoix = Cells(i, 1) Then
[COLOR="Blue"]pFichier = chemin00 & "\" & Cells(i, 3) & "_DataRESULT" & sDate & ".xls"[/COLOR]
[COLOR="Blue"]Set wb = Workbooks.Open(chemin01 & "\" & Cells(i, 4) & "\" & sFichier & ".xls")[/COLOR]
wb.SaveAs pFichier
End If
Next
End Sub