Dear all,
I have these several huge excel files, each with a lot of sheets. I have to manually search each of them for specific string and to check if it exists somewhere.
I have found the following code and so far it works. But in order to search for a string, every time I have to open the code and change the path and the search word:
'Change as desired
strPath = "c:\MyFolder"
strSearch = "Specific text"
Instead of opening the code and changing the path each timе, I would like somehow to have a search field or something like this on the picture attached. Is it possible?
5KHw6.png
Or for example two cells on the sheet with the results, where I can put the path and the search word, without opening the code?
I hope my inquiry is understandable.
I would be very grateful for the help.
Rali
Bookmarks