Here is the problem:
I have a Word Document that has an object (Excel chart) links to Chart in another Excel document. So there is this property of Links in Word document that contains Souce File, Item in File, Link Type. By changing the value of these property, different chart can be linked from Word document.
VB macro required:
1) Source File property contains the absolute path of the linked Excel file name, I will like to change the path using VB macro
2) Changing the value of "Item in File" and Link type is also needed.