vba to search for a word in files in a directory

Hi

I have seen several examples of VBA to find files by file name or property, but is if possible to use VBA to search all files (not just excel) in a directory to find a particular word or phrase in the file?

Thanks Leith
could you point me to the VBA commands (filesearch apparently no longer works)
or.. is it necessary to open each file to search it?

Hi Leith
both word and excel files, if possible.

Hi Leith

I was really hoping to create a dialog box that would reproduce the functionality of the old search box in windows many years ago – when a single box allowed you to specify which directories to search, whether to search subdirectories, file names or partial file names, file types, words or whole phrases in documents, date created, file size etc. I can manage most of this because the search items are file properties, but was hoping for something equivalent to the “search in file contents” command

Thanks Leith for your comments

I may try to create a dialog box based on your suggestion of opening files, and stick to using it one directory at a time.

It's another on the long list of useful features that Windows (doubtless for good reasons) has withdrawn over the years. I still pine for the capcity to record macros in PowerPoint, too!