Change item source for linked excel object by VBA

[koticphreak]

So I have a bunch of linked excel objects pointing to \\stuff-01\personal\

and now all those excel files are in \\stuff-02\global\

I've tried a couple different variations and can't seem to figure out how to write a vba to change all the word field links to replace a portion of the source file path - anyone have an idea how to do this?


Thanks!

p.s. I found these, but it's a bit over my head in terms of how to modify it to do what I'm trying:
http://answers.microsoft.com/en-us/o...c-68b599b31bf5

http://social.msdn.microsoft.com/For...in-field-links