I have a folder containing over 200 workbooks. One of them has a specific VBA macro that I am looking for. Is there a way to search multiple workbooks for a text string from specific macro program for sub routine? I really don’t want to have to open each workbook, open the VBE and search for the string one at a time. Thanks!
Asked
Active
Viewed 259 times
0
-
search VBE automation. – cyboashu Jan 10 '17 at 19:13
-
Start here: http://www.cpearson.com/excel/vbe.htm – Tim Williams Jan 10 '17 at 19:27
-
[This answer](http://stackoverflow.com/a/40613854/4088852) is essentially what you're after, minus a Workbook loop - just test for your macro declaration instead of a comment. – Comintern Jan 10 '17 at 20:34