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 EditCopy
2) going to a MS Word document clicking EditPaste SpecialPast 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