Option Explicit
Sub ImporterL13L67()
Dim NomFic As String, L As Long, TRés()
ChDrive ThisWorkbook.Path: ChDir ThisWorkbook.Path
ReDim TRés(1 To 10000, 1 To 2) As Variant
NomFic = Dir("*.xl*")
While NomFic <> ""
If NomFic <> ThisWorkbook.Name Then
Workbooks.Open NomFic
L = L + 1
TRés(L, 1) = ActiveSheet.[L13].Value
TRés(L, 2) = ActiveSheet.[L67].Value
ActiveWorkbook.Close False: End If
NomFic = Dir: Wend
Feuil1.Cells.ClearContents
Feuil1.[A1].Resize(L, 2).Value = TRés
End Sub