Dim RDir As String, NomFic As String, FDT As Date, Récent As Date
ChDrive "C": ChDir "C:\Users\Desktop\TVA"
RDir = Dir("D*.xls")
Do While RDir <> ""
FDT = FileDateTime(RDir): If FDT > Récent Then NomFic = RDir: Récent = FDT
RDir = Dir: Loop
Workbooks.Open Filename:=NomFic