Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can Excel search for workbook data in a Windows folder? | Excel Discussion (Misc queries) | |||
Unknown excel backup files created in network directory | Excel Discussion (Misc queries) | |||
A Search Engine inside Excel Spreadsheet | Excel Discussion (Misc queries) | |||
how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? | Excel Discussion (Misc queries) | |||
I would like to print the titles of files inside a folder. | Excel Worksheet Functions |