Macro to Keep Linked Workbooks Updated
 

Using Excel 2000/XP. We have store locations that dial in using VPN to
place their orders on a file on the server. This files links to history
files so they have a running history of their previous orders. If someone
inside the home office network accesses the file, the links have to be
updated because the path they access the file is different from the VPN
connection. The same applies if I were to access the files from the server
itself.

Is there a Macro that will tell the workbook where the linked files are
located regardless of how and from where the file is opened?

Thanks in advance!!!!

--
Remove 'spam' from email address to contact me directly