Import dynamic filname

Perhaps a construction along these lines if you a checking a number of files in a folder?

Dim FileName As String
FileName = Dir("C:\tester\*.csv")
Do While Len(FileName) > 0
   If Right(FileName, 11) = "_Future.csv" Then
Your code goes here
   End If
    FileName = Dir
Loop

Alf