If you only require the filename in which the search word is in; then why
dont you try Windows search?
--From windows explorer right click the parent folder.Search
--From the search window 'All or part of filename' mention *.xl*
--In the secong text box 'A word or phrase in the file' enter your search
keyword and hit 'Search'
"Evan" wrote:
anyone know of a search macro or VB script that can perform searches for cell
entrys such as SKUs along multiple Excel spreadsheets? I need a fast way to
search for specific entrys in hundreds of spreadsheets.
Thanks Evan