I have a folder containing hundreds of xlsm files.
Can anybody recommend a utility that scans for text in macros ( VBE/IDE ?) and not in the actual worksheets.
I often know a keyword that is used in a particular macro, but am unaware of which xlsm file uses it.
A macro that can actually do this, would be sensational.
Thanking you in advance.