Automatically Updating Links Between Workbooks

PapaBear56

New Member
Joined
Jul 25, 2005
Messages
5
I've been trying to figure out how, using VBA, to automatically update links between multiple workbooks, without success. What I have is a workbook that links with other workbooks. Where the problem comes in is when the workbooks are run from different computers and the location paths of the linked workbooks change. Granted, this can be easily handled manually but I want it to do it automatically.

What I think it needs to do is:
1. Identify what system the main workbook is being run on.
2. Depending on what system it is running on, determine if and where the linked workbooks reside.
3. Update the links.

For speed purposes, it would also be helpful if the newly updated linked workbooks could be opened if they aren't already.

Thanks in advance for any help anyone can provide.
 

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top