It is possible but not trivial. Chances are you would not capture all links
and references, which would compound the issue. Also if the VBA code is
protected you are going to have trouble reading and changing it.

--

Regards,
Nigel




"Clinton M James" wrote in message
...
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