Hi everyone,

First time on a forum.

I'm fairly new to excel vba and I'm currently using 2010.

I'm looking for a code in Excel vba that will:
- Take a string from a cell A1 i.e. "hello" and search a folder with 20 word files for that string.
- The output will be a list of file names (rows B1 to B..) in which "hello" appears at least once.

Is this possible? I've research into Dir and wildcard functions but I'm too much of a novice to even begin.

Any help would be greatly appreciated.

Thanks.