search folder/directory for a phrase inside excel files
 

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?

search folder/directory for a phrase inside excel files
 

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?

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?

search folder/directory for a phrase inside excel files
 

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

On Sun, 10 Aug 2008 20:41:01 -0700, pwrichcreek
wrote:

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?

search folder/directory for a phrase inside excel files
 

Did you try the free version?

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

Phil

"Gord Dibben" wrote:

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

On Sun, 10 Aug 2008 20:41:01 -0700, pwrichcreek
wrote:

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?

search folder/directory for a phrase inside excel files
 

Good to hear.

Thanks for the feedback.


Gord

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

Did you try the free version?

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

Phil

"Gord Dibben" wrote:

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

On Sun, 10 Aug 2008 20:41:01 -0700, pwrichcreek
wrote:

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?