Need to loop through excel files in a folder, find and replace VBA code

[PeterMac65]

Hi,
Recent Dropbox changes have caught me out. I need to change 2 rows of code in excel modules for two hundred files.

Can anyone tell me how to loop through files in a folder & then search and replace 2 lines of code?

In the mean time I'll keep reading and maybe find something useful

Regards Peter

 

[Micron]

The VBIDE object hierarchy is one of those VBA things that I gave up trying to wrap my head around. Perhaps this link will help if you can blend it with researched code that loops through files in folders and subfolders (and there's lots of example for that):

Change VBA coding with VBA Coding

I need to change a constant, that references a web address. Our ADI templates have a new server path and it would be easier to update the code than download all new templates. How can I update the...

stackoverflow.com

I think you would just need to provide the string you have and the string you want to replace it with.