I have a Word doc with links to Excel. Is there a way using Word VBA to break the links to Excel?
H heidi Dec 4, 2003 #1 I have a Word doc with links to Excel. Is there a way using Word VBA to break the links to Excel?
M Martin Seelhofer Dec 4, 2003 #2 I have a Word doc with links to Excel. Is there a way using Word VBA to break the links to Excel? Click to expand... Yes. E.g: Selection.InlineShapes(1).LinkFormat.BreakLink .... which breaks the link for the first selected inlineshape. Or: Selection.ShapeRange(1).LinkFormat.BreakLink .... to break the link to the first selected shape. Cheers, Martin
I have a Word doc with links to Excel. Is there a way using Word VBA to break the links to Excel? Click to expand... Yes. E.g: Selection.InlineShapes(1).LinkFormat.BreakLink .... which breaks the link for the first selected inlineshape. Or: Selection.ShapeRange(1).LinkFormat.BreakLink .... to break the link to the first selected shape. Cheers, Martin
