Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 11th 08, 03:10 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 34
Default 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?

  #2   Report Post  
Old August 11th 08, 04:13 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default 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?


  #3   Report Post  
Old August 11th 08, 04:41 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
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?



  #4   Report Post  
Old August 11th 08, 05:08 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default 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?




  #5   Report Post  
Old August 11th 08, 06:26 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 34
Default 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?






  #6   Report Post  
Old August 11th 08, 09:39 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default 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?







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can Excel search for workbook data in a Windows folder? B Diggity Excel Discussion (Misc queries) 1 October 25th 07 10:24 PM
Unknown excel backup files created in network directory Mike Excel Discussion (Misc queries) 0 September 18th 07 01:26 PM
A Search Engine inside Excel Spreadsheet Edgar Excel Discussion (Misc queries) 2 March 29th 06 04:51 PM
how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? Raven Excel Discussion (Misc queries) 1 January 24th 06 03:28 PM
I would like to print the titles of files inside a folder. onenevadadollar Excel Worksheet Functions 1 November 17th 05 12:26 AM


All times are GMT +1. The time now is 01:52 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017