Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking specific text string in excel files stored in a folder
Hi,
can someone please help me with the above problem? Many thanks. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking specific text string in excel files stored in a folder
Thank you Dave. It helped a lot.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pulling pdf files from general folder to specific folder | Excel Discussion (Misc queries) | |||
How to search Excel files based on a specific text string in VBA c | Excel Discussion (Misc queries) | |||
FYI: One macro really helped for capturing data from multiple workbook stored in a specific folder to one excel file only | Excel Programming | |||
how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? | 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 Programming |