HELP: Is it possible to use VBA to update links in multiple workbooks?
 

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

Is it possible to use VBA to update links in multiple workbooks?
 

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

Is it possible to use VBA to update links in multiple workbook
 

I don't know about updating VBA code, but this resource may give you some
ideas that you can work with:
http://www.rondebruin.nl/copy4.htm

Good luck,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Nigel" wrote:

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