search folder/directory for a phrase inside excel files

[pwrichcreek]

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?

 

[Gord Dibben]

Agent Ransack will do the job.

http://www.agentransack.com

Free download.


Gord Dibben MS Excel MVP

 

[pwrichcreek]

Thanks for your reply Gord.

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

 

[Gord Dibben]

Did you try the free version?

I have the free version 1.7.3 Build 325 and it finds text in all Excel
files.


Gord

 

[pwrichcreek]

Did you try the free version?

I have now!!! Works great. Many thanks for your help.

Phil

 

[Gord Dibben]

Good to hear.

Thanks for the feedback.


Gord

I have now!!! Works great. Many thanks for your help.

Phil