Use VBA to search for a string in another file's macros

[cjindenver]

Hello. I have several dozen Excel reports that I manage. I am preparing to leave my company and want to leave them in a good place after I leave. I know some, but very few, of my macros have my email address hard coded instead of just referencing a cell where the value can be updated. Is there a way to use VBA in one workbook to search for a string in the macros of other workbooks? Maybe this questions already exists, but I can't find it if it does. Thanks in advance!

 

[Fennek]

Hi,

a way is to use oledump.py from Didier Stevens on a Linux PC

oledump.py -s a -v your.xlsm | grep youremail@isp.com

Oledump accept only one file, so you need a litte bash-script to pass all files of a directory

regards