I have a macro in Excel that opens a word document and updates the links. It is linked to the excel file. Then i do a "save as" of the word document and then i want to break the links in the word document. I can't figure out the code to do this, i looked in the help and it say to use this code...
Dim shapeLoop As Shape
For Each shapeLoop In ActiveDocument.Shapes
If .Type = msoLinkedOLEObject Then
but the word document contains excel objects which i don't think are "shapes".
Anyway, can someone tell me the proper code to use an excel macro that is controlling word to break the word links to excel. thanks