View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
pwrichcreek pwrichcreek is offline
external usenet poster
 
Posts: 34
Default search folder/directory for a phrase inside excel files

Thanks for your reply Gord.

According to the feature compare list, only the PRO version ($30) can search
EXCEL files.

"Gord Dibben" wrote:

Agent Ransack will do the job.

http://www.agentransack.com

Free download.


Gord Dibben MS Excel MVP


On Sun, 10 Aug 2008 19:10:00 -0700, pwrichcreek
wrote:

I need to search all the excel files in several directories for a specific
phrase. The phrase in question is contained in the source vba code associated
with the excel files. Windows/XP search (explorer) does not find the phrase,
not even in one of the files that I checked manually and verified the phrase
is there. Is the vba source code stored in plain text and in the same
location as the related excel file?

Is there a tool that will do this kind of search?