How to Find & Replace a particular string (an email address) found within all excel files within one folder

[thankyou]

Hi. I'm wondering if anyone can provide a quick way to do a find & replace one email address that's in a few hundred excel files that are all within a single folder. Thanks very much for your solution and your time.

 

[thankyou]

Thanks Z/G. No, maybe it was my line break:

It's the line you mentioned Zack, but only the 1st instance of the word wbOpen on that line you cited correctly. I meant it was highlighting in blue the word "wbOpen" (no quotes) of that line when I hit F5 (run macro), giving that compile error (and I still get it if I run GTO's version on even a different folder, ie "Compile error: only comments may appear..." thx, Ben

 

[Zack Barresse]

With your cursor in the module, press Ctrl + A, then paste it in a post here, so we can see everything in the module.