Excel VBA search multiple files for text in txt files and return the line/paragraph containing that word

[rockstar1989]

Hello,


I have found an excel macro enabled file which search for a specific word in all documents in a specific folder, if the word is found then it returns the mark 'x' against the file name. Check attachment.


I want this to return whole line or paragraph containing that searched word instead ho returning 'x'.


Can somebody help me in doing this task. I will be grateful.


Thanks