Re: Referencing an imbedded Excel work***

Thanks, Peter. I'm running Word 2002, but I don't think that makes a
difference.

Expanding on your thinking, I tried this:
{Ref { LINK Excel.***.8 "C:\\Documents and Settings\\me\\My
Documents\\embedded.doc" _1224002984!Sheet1!R3C2 \a \t }\# " 'increased by '; 'reduced by ' "}
but got this:
Error! Reference source not found.

I'm stumped. Anybody else have a brain wave?

David


"Peter Jamieson" wrote:

In Word 2003, once you have embedded the Excel ***, if you
a. select the cell
b. right-click, copy
c. in Word, Edit|Paste Special and choose Link and Unformatted text, then
you should see a

link field along the lines of

{ LINK Excel.***.8 "C:\\Documents and Settings\\me\\My
Documents\\embedded.doc" _1224002984!Sheet1!R3C2 \a \t }

When you update the embedded object, the link also updates, but
a. I have never used this technique in a production system
b. on my test system it was very slow, and I even saw a message or dialog
box about Word wiating for an OLE operation to finish
c. I do not know what exactly the _1224002984 refers to, or in what
circumstances this reference ID might change. if you rename the document in
Windows Explorer, the link is unlikely to update correctly (you could
consider using an embedded field such as { FILENAME /p } instead but I
haven't tried).
d. you may find that the value of Word Tools|Options|General|Web
options|Files|"Update links on save" has an impact on whether or not this
field evaluates correctly

Peter Jamieson

"Compass Rose" <CompassRose@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AF6D8F60-257F-4626-9344-D288B8D4277F@xxxxxxxxxxxxxxxx
I have a Word document that contains an imbedded Excel work***. One of
the
cells of the work*** can have an either positive or negative value. I
have
some text in my document that has to be either "increased by" or "reduced
by", depending on the value of the cell in the Excel work***.

Can that cell be referenced with a FIELD (or otherwise)?

TIA
David

P.S. If I have to, I can change the imbedded work*** to a table with
formulas in it, and bookmark the cell of the table, but its not my first
choice.



.