Re: field = to

First: don't know why your link isn't updating. The _121... bit is a
Word-generated bookmark. When I tried it, I got a reference like that with
the document not saved, replaced by OLE_LINK1 (which is also an automatic
bookmark) when the document was saved.
Did you try updating fields?

As for making the cell reference variable: in principle you should be able
to name the cell, then use the cell name in place of the "R8C2" -- this
certainly works from a linked workbook. Never tried it with an embedded
***.



"Joanne" <jobobbuss@xxxxxxxxxxxxx> wrote in message
news:eZb8HtKsGHA.1208@xxxxxxxxxxxxxxxxxxxxxxx
Jezebel
Here is my link, which is not updating when I make changes:
{LINK Excel *** 8 "C:\\Documents and Settings\Joanne\\My
Documents\\non-discount.doc" "_1215402019!Sheet1!R8C2" \a \t

Can you see where I might have made a mistake that is causing it to
not update?
And while I have your busy attention, is there a way to pass the cell
addr from the excel *** as a variable to the link so that if the
list happens to be longer, it will still update?

Thanks for your time
Joanne

Jezebel wrote:

Select and copy the total within the embedded ***.
Select the location in the document where you want the total to appear.
Click Edit > PasteSpecial. Check 'Paste Link' and select 'Unformatted
text'
from the 'As' list.

You'll end up with a field that looks something like --

{ LINK Word.Document "C:\\MyFolder\\MyFile.doc" "OLE_LINK1" \a \t }

This will update automatically when the embedded *** changes.




"Joanne" <jobobbuss@xxxxxxxxxxxxx> wrote in message
news:ei4FXZEsGHA.3412@xxxxxxxxxxxxxxxxxxxxxxx
I have an excel table in my document.
It lists invoice numbers and their amounts, then gives me a total.
What I would like to do is make a field in my doc = to the total
generated by the excel table.
Looking at insert/fields I don't know whether to use doc automation,
links and references, equations and formulas or if none of the above
are correct.
Please give me some help on this problem
Thanks a bunch ahead of time
Joanne





.

Loading