Checking specific text string in excel files stored in a folder

A

AG

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.
 
A

AG

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top