Sub Ouvre_le_dernier_xls()
Set wk = ThisWorkbook
Dim Chemin As String
Chemin = "C:\Users\jeux\Desktop"
'Chemin = ThisWorkbook.Path
y = DernierFichierCreer(Chemin)
If y <> "" Then
Z = Chemin & "\" & y
Workbooks.Open Z
wk.Activate
Range("G12").FormulaR1C1 = "='[" & y & "]Feuil1'!R4C2"
End If
End Sub