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?