Hi,
I have an excel spreadsheet linked to a word document. The spreadsheet gets filled with appropriate numbers by running a macro, and then the word document is updated by the links. However, I want to save the word document as a unique file and break the links at the end of the macro (so it can't be updated with new numbers that go into the spreadsheet). I know how to save the word doc in the excel macro, but I can't figure out how to break the links. How can I do this?
There is something called Linkformat.breaklinks in Word, but I cannot figure out how to use it properly. I need to break all the links in the word doc, so it needs to loop through it somehow, check for links, and delete if it finds one.
Thanks for your time and help.
Bookmarks