Macro to open, update links, save then close all files in sub folders

Hi All,

Was looking for some help with a macro. I found the macro below on this forum. I think its what i want but i dont want it opening files in the subfolders' subfolder. I hope that makes sense. I have my parent folder with a bunch of subfolders. Each subfolder has an xlsm file and another subfolder in it. I just want it to open the xlsm file, update links, save and close then move on to the next subfolder of the parent folder.

Thank you in advance

Please Login or Register  to view this content.

So I am guessing that path in the first LoopStarter is the parent folder, no files are opened there. You need the Looper to go down one more folder to find a file, then NOT go any deeper into that one folder?

In that case I would recommend 3 macros instead of two.

LoopStarter - what you currently have

SubFolderFinder - a new macro that is the second part of the current Looper, just the part that finds SubFolders and calls the Looper.

Looper - just the first half of your current Looper, only the part that loops through files in the one folder.