There and Back Again: Dynamic Linking from Word to Excel

Field codes: Link field - Word - Microsoft Office Online

Dear Absolutely Everyone,

This information is for you! Have you even wanted to construct a Word document with a link to information in an Excel document that would dynamically update every time you updated the Excel document. "Yes," you say, "of course." Well, the answer to this is "Paste Special."

I never realized that Paste Special created a field.

Copy the cell or range from Excel. 'Paste special' into Word. If you choose the link option from the dialog box, it will automatically update whenever you update and save the Excel file. "This," you are saying, "is good stuff." I knew you'd like it.

Of course, a lot of you already knew this, but you are just saying, "Why didn't she ask."

The code for the pasted field is viewable, by the way, if (in Word) you go to Tools/Options/View tab and check Field codes.

When you do, you'll see code like this.
{LINK Excel.Sheet.8 "C:\\Documents and Settings\\bubba\\My Documents\\test.xls" "Sheet1!R1C3" \a \t}

Let's not discuss all this code, but if you are working with something like this, you may want an example to look at.

Betsy