VBA Code help - Search files within folders and return file name and path

[jesmac]

Hi there,

I am very new to VBA and I have a problem that I know VBA can help me with but I can't figure out the coding.

I have a folder with subfolders and hundreds of files within them.
I have a list of ~500 terms that I need to remove from these files so I need a code that will search the files for my specified terms and tell me what files they are in (the file name and path).
I have excel and word documents that I need to search through.

I have found codes that are supposed to help me and I have tried few, but I can never get them to work 100%.

Someone help me please!!!!

[SamT]

Moderator Bump