need a way to search all worksheets vba code

[Stevelen]

I often need some VBA code, and realize that I wrote working code for what I need a
few years ago. I need a way to search all my worksheets (over 200 of them), probably by a
comment I wrote to myself.

I tried a few different GREP programs for *.xlsm but it seems like none of the grep
programs I have can read through VBA code withing an xlsm file.

Is there a way to automate opening each spreadsheet, clicking on each module, selecting all, and
pasting to a large extername txt file? I could then use Notepad to search. Thank you.

 

[yky]

This thread might help.

Searching VBA Code in several xlsm files