Hi All,

I am re-orgnaizing folders in the office I work, problem is another team is
using our team's folder to store their stuff.

I am about to evict them into their own folder, however doing so will cause
issues which are critical to the business.

I am looking to have code go through every excel workbook it finds in their
subfolders and change the links to point to the new folder I will be moving
the data to. Is this possible?

is it also possible to make it detect any VBA code in any workbooks and
update the code to the new folder as well?

Any help is appreciated and I extend a thank you in advance.

Cheers,
Clint