View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jackpot Jackpot is offline
external usenet poster
 
Posts: 46
Default Search Macro or VB script

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