Search for file in directory

ryanlcs,

Check out the following code that will run on any *.csv file containing "FGIVAL" within its' name.

Set fs = Application.FileSearch
    
    With fs
      .LookIn = DefaultFolder
      .Filename = "*.csv"
      
      If .Execute > 0 Then
        
        For i = 1 To .FoundFiles.Count
            If InStr(.FoundFiles(i), "FGIVAL") > 0 Then
            'Some code
            End If
        Next i
        
      End If
      
    End With

HTH

Robert