Search all files within a directory and subfolders for a string

[sonzy]

Hi,

I need some help writing VBA code where you input a search term and all files within a directory and all its subfolders which contain that string are found. The code should then delete all rows in all files that contain the specified string. File format would be csv,

 

[sonzy]

Re my question above, I have done the below so far but it doesn't work (I get an error saying "Invalid Next Control Variable Reference")

Sub Button1_Click()
Dim fileName As Variant
Dim wb As Workbook
fileName = Dir("C:\Users\Sonal Kanabar\Documents\Test folder 3\*.csv")
While fileName <> ""
Set wb = Workbooks.Open(fileName)
    Dim cell As Range
For Each cell In Selection
    If InStr(1, cell, "andy.schwartz@nmfn.com", vbTextCompare) > 0 Then
        cell.EntireRow.Delete
        ActiveWorkbook.Close SaveChanges:=True
        Exit Sub
    End If
Next fileName
    'Set the fileName to the next file
Wend


End Sub