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.
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.