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.
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.