tindavid
asked on
How to change the Source File for a linked Excel Cell in a Word document by Macro and VB
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.
T8-Weekly-Report--thisweek-.doc
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.
T8-Weekly-Report--thisweek-.doc
ASKER
Hi Graham;
I want to execute this type of macro from Excel, that is using macro to open an word document and :
1) change the links within the word document
2) also how can I insert few blank/dummy lines when I find a key word in the word document.
many thanks
I want to execute this type of macro from Excel, that is using macro to open an word document and :
1) change the links within the word document
2) also how can I insert few blank/dummy lines when I find a key word in the word document.
many thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Open in new window