Search multiple workbooks for string - better visualisation

[ralitsa.b]

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?

Please Login or Register  to view this content.

I hope my inquiry is understandable.

I would be very grateful for the help.

Rali