Linking text from imbedded MS Word objects in Excel to an MS Word

[KG]

I have a large number of Excel worksheets, each one with an imbedded
Microsoft Word Object that describes the assumptions for that particular
worksheet.

One of my colleagues asked if it would be possible to gather the text from
all these MS Word objects in a linked Word document, so that there would be a
central collection point for all the assumptions. The request is for the
links to be dynamic so that the Word document would be updated each time a MS
Word object in the Excel workbook is modified.

I tried this by:

1) clicking inside the MS Word object, choosing Select All, then Edit>Copy
2) going to a MS Word document clicking Edit>Paste Special>Past Link

I have been getting very erratic results. In some instances the text gets
updated, in others it does not, and yet in others MS Word reports an error to
the effect that the specified source could not be found. Is there a workable
procedure for this task? Also, should the Paste Link format be Formatted
Text, HTML or something else?

Your help would be greatly appreciated

KG

 

[Jezebel]

You've got the right idea, but you're going at it the wrong way round. I
suggest trying it like this --

1. Create a single Word document containing all the assumption text, by
cutting and pasting from the embedded objects in Excel.

2. Make a copy of your Excel document. Delete all the embedded objects.

3. For each of the pieces of assumption text, select the text in the Word
document, copy, switch to the Excel workbook and PasteSpecial as an embedded
object. Thus each embedded object in Excel refers to a part of the Word
document.