Break Link to Excel Diagram from Word

Hi!

I'm trying to write a code that can break a link to an Excel diagram from Word. I have tried several different alternatives but none have been successful.

I have an Excel workbook that is updated on a daily basis. The workbook contains several diagrams that have been copied and pasted as a linked objects into a write-protected Word-document. I have written a macro that will save the document with a new name but I also want a macro to break the link to the Excel workbook. Any ideas?

Welcome to the Forums.

When youbreak the link you may loose your diagram since there is no source
to pull the diagram in from. You probably would want to make it an embedded
object so it will be independent from the original document/workbook.

Does this sound like what you need?