Loop through each file in folder and look for specific character strings

Sub FINDlinesinfolder()


    MsgBox ("Please choose the folder")



    Application.ScreenUpdating = False

    With Application.FileDialog(msoFileDialogFolderPicker)
        .AllowMultiSelect = False
        .Show
        If .SelectedItems.Count > 0 Then
            fd = .SelectedItems(1)
        End If
    End With



    fn = Dir(fd & "\" & "*.*")

    
        Set ws1 = Workbooks("myvalue.xls").Sheets(1)

'I set my sheet that contains the values I want to look at


        ws1.Cells(1, 17) = "Found in following file"
        ws1.Cells(1, 18) = "found on following line"

        Do While fn <> "" ' I loop through each file



            Set ws2 = Workbooks.Open(fd & "\" & fn).Sheets(1)
            lr2 = ws2.Cells.Find(What:="*", After:=[A1], SearchDirection:=xlPrevious).Row

            For i = 1 To 600 ' I loop through my 600 values


mydate = Right(ws1.Cells(i, 2), 4) & Mid(ws1.Cells(i, 2), 3, 2) & Left(ws1.Cells(i, 2), 2)
                myaccount = WorksheetFunction.Substitute(ws1.Cells(i, 5), "-", "")
                myamount = WorksheetFunction.Substitute(ws1.Cells(i, 3), ",", "")

'My values are a combination of the formatted value of 3 cells
'i could input only the end result in python

                For y = 1 To lr2
                    If mydate <> "" Then
                        If ws2.Cells(y, 1) Like "*" & mydate & "*" & myaccount & "*" & myamount & "*" Then                            ws1.Cells(i, 17) = fn
                            ws1.Cells(i, 18) = y
                        End If
                    End If
                Next y

'If the line in the text file is like "wildcard" & mydate  & "wildcard" & myaccount & "wildcard" & myamount then write filename and  line in my original excel file

            Next i ' loop each line

            ws2.Parent.Close False


            fn = Dir



        Loop 'loop each files
 

    End Sub

>>> import os
rootdir='c:\test\'
def myscan(line):
    return line
for subdir, dirs, files in os.walk(rootdir):
    for file in files:
        f=open(file, 'r')
        lines=f.readlines()
        for line in lines:
            if "mytest"
            in line: print f.path
        f.close()
        

import os

rootdir='c:\\test\\'  # The backslashes are a problem.

for subdir, dirs, files in os.walk(rootdir):
    for file in files:
        with open(file, 'r') as f:
            lines=f.readlines()
        for line in lines:
            if "mytest" in line:
                print f.path


# In unix, I'd use this command

# find root_path -type f -exec grep --silent mytest {} \; -print

import os

rootdir='c:\\test\\'  #rootdir seems to be the directory where is located my python project (.py file) and not c:\test\. How do I solve this.

for subdir, dirs, files in os.walk(rootdir):
    for file in files:
        with open(file, 'r') as f:
            lines=f.readlines()
        for line in lines:
            if "aaa" in line:
                with open("Output.txt", "w") as text_file:text_file.write(f.name)
                f.close() #my loop does not seem right because even tought I have multiple files that contains 'aaa' it only prints one

import os

rootdir='c:\\test\\'  #rootdir seems to be the directory where is located my python project (.py file) and not c:\test\. How do I solve this.

with open("Output.txt", "w") as text_file:

    for subdir, dirs, files in os.walk(rootdir):
        for file in files:

            with open(file, 'r') as f:
                lines=f.readlines()
            # f is closed when the code finishes the block

            for line in lines:
                if "aaa" in line:
                    text_file.write(f.name)
                    break # I assume you don't need to write the name for each occurrence of the target string 

# python closes text_file when you get back to this indentation level.