Hello, I'm really new to vba and I'm trying to build a code that finds multiple text in different files located in different subfolders and replace it with other text that I've set up in an Excel sheet.
However, when I execute the code (regardless of whether all at once or step-by-step), sometime it opens the same file more than once, making it take longer than it really should.
Here's what the code looks like so far:


Please Login or Register  to view this content.

I know there are probably a lot of things that can be shortened using other vba functions but as I said I'm really new, and any help would be appreciated. The code does change the text specified in the first range to the text specified in the second range (so it actually works), but it takes too long precisely because it opens files more than once (sometimes up to 14 times).