'============================================================================================== Dim fso Dim parentpath Dim parentfolder Dim resultfilename Dim inputfilename Dim inputfile Dim resultfile
Set fso =CreateObject("scripting.filesystemobject") 'Get target folder path that all files under it and its sub folder will be search for. parentpath =Trim(InputBox("Please Input Find Target Path","Target Path")) 'Get input file that contains word which you want search it in the target folder. inputfilename =Trim(InputBox("Please Input INPUT File Path","File Path")) Set parentfolder = fso.GetFolder(parentpath) resultfilename=parentfolder.ParentFolder.Path &"\result_compare.txt" Set inputfile = fso.OpenTextFile(inputfilename) Set resultfile = fso.CreateTextFile(resultfilename) Dountil inputfile.AtEndOfStream inputfileline=Trim(inputfile.ReadLine) If inputfileline<>""Then resultfile.WriteLine "===================================================================" resultfile.WriteLine "Parent Folder : "& parentpath resultfile.WriteLine "Find String : "& inputfileline resultfile.WriteBlankLines 1 resultfile.WriteLine "File name"& vbTab &"Line Number"& vbTab &"Target String"
resultfile.WriteLine "===================================================================" EndIf Loop Set fso=Nothing WScript.Quit
'============================================================================================== Sub processFiles (parentfolder,inputfileline,resultfile,parentpath) ForEach subfile In parentfolder.files Set ts=subfile.OpenAsTextStream line=0 Dountil ts.AtEndOfStream line=line+1 content=Trim(ts.ReadLine) If content<>""Then IfInStr(LCase(content),LCase(inputfileline))>0 Then resultfile.WriteLine Replace(subfile.Path,parentpath,"")& vbTab & line & vbTab & content EndIf EndIf Loop Next 'This is important for this sub. If parentfolder.SubFolders IsNothingThen ExitSub EndIf ForEach subsubfolder In parentfolder.SubFolders processFiles subsubfolder,inputfileline,resultfile,parentpath Next EndSub '==============================================================================================