Unlink graphics in VBA
Dear all,
Does anybody know how I can break links (coming from excel graphics)in word
using VBA in excel?
I have a macro which opens a word document, then removes the links to word
(except the graphs links) and save the word document.
the following solutions did not help me:
ActiveDocument.Fields.Unlink
Sub RemoveLinks()
Dim aField As Object
For Each aField In ActiveDocument.Fields
aField.LinkFormat.BreakLink
Next aField
End Sub
thanks,
Jan
|