Search for a line in all Modules in a workbook and add extra line below

Hello,

I would like to search for a line of code in all modules in a workbook and add additional code below it. For example, search for:

wb1.Close SaveChanges:=False

and below it add

wb2.Close SaveChanges:=False
wb3.Close SaveChanges:=True


I searched at the cpearson website but had no success editing any of the examples provided. Can vba be used to edit modules as I described above or is a workaround necessary?

Thank you

Hi Leith,

Yes, I'm referring to the modules in the Visual Basic Editor. I have more than around 120 modules which I need to edit in several workbooks. It would be very time consuming to edit them manually hence my original question.

Thank you for the reply.

Hello,
If anyone knows how to do this with vba it would save me a lot of time. I don't know if it's easier but a search and replace would also work,

i.e. search for

wb1.Close SaveChanges:=False

and replace it with

wb1.Close SaveChanges:=False
wb2.Close SaveChanges:=False
wb3.Close SaveChanges:=True


Thank you