Checking specific text string in excel files stored in a folder
Hi,
I need to write a code that can do the following: 1) prompt user to select a particular folder 2) search for a particular text string, for e.g., ABCD in all the excel files in that folder (the number of files in the folder will vary and so does the names of the files). Is it possible to specify the string that we want to search on the fly when macro is run? 3) create a simple report that contains the filename in one column and yes / no in the second column that tell me which file names contain that keyword (it will be great if the path of the file can be recorded in the 3rd column that we can click to open the file). Currently we do this manually and I am looking for a way to automate the same. Any help on this will be much appreciated. Thanks. |
Checking specific text string in excel files stored in a folder
One thing I forgot to mention is once the user selects the primary
folder then there will be subfolders that contain the excel files. The name and number of subfolders and the excel files inside them both vary. Capturing the path to the excel files will really help us. Thanks. |
Checking specific text string in excel files stored in a folder
Hi,
can someone please help me with the above problem? Many thanks. |
Checking specific text string in excel files stored in a folder
Maybe you could use Chip Pearson's addin:
http://www.cpearson.com/Excel/FolderTree.aspx Get your list (in column A) and use a formula like: =countif(a1,"*abcd*")0 in column B AG wrote: Hi, I need to write a code that can do the following: 1) prompt user to select a particular folder 2) search for a particular text string, for e.g., ABCD in all the excel files in that folder (the number of files in the folder will vary and so does the names of the files). Is it possible to specify the string that we want to search on the fly when macro is run? 3) create a simple report that contains the filename in one column and yes / no in the second column that tell me which file names contain that keyword (it will be great if the path of the file can be recorded in the 3rd column that we can click to open the file). Currently we do this manually and I am looking for a way to automate the same. Any help on this will be much appreciated. Thanks. -- Dave Peterson |
Checking specific text string in excel files stored in a folder
Thank you Dave. It helped a lot.
|
All times are GMT +1. The time now is 06:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com