search folder for file

I'm using Excel 2007, so no .filesearch

I want to search a folder for a file containing a certain phrase. Would like to use a case option like in java.

search for file containing "aaa", "bbb", "ccc", or "ddd"

then if file exists

Select Case True
    Case file contains "aaa"
        Run macro aaa
    Case file contains "bbb"
        Run macro bbb
    ...
End Select

-I'm not sure the correct syntax for the above.

This is gonna be a long process to get the code where I want it, but I taking one step at a time, so I understand what is happening and I can change if I need.

TIA

Wanted to add that the folder can be set to only have 1 file, but would like to be able to have multiple files while testing.