Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Linking text from imbedded MS Word objects in Excel to an MS Word
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 |
#2
|
|||
|
|||
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. "KG" wrote in message ... 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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Boiletplates from Word Perfect | Microsoft Word Help | |||
How do I create & merge specific data base & master documents? | New Users | |||
Excel worksheet in Word linked text boxes | Page Layout | |||
How to change merge forms from Word Perfect to Microsoft Word | Microsoft Word Help | |||
Outline | Page Layout |