I don't know whether it's a problem with the LINK field or not, but it's
certainly the case that EQ fields have this problem: the default space at
the end of the field code is carried over into the document; it is necessary
to remove the space to get the desired result. You might see what happens if
you use the field below as follows:
{ LINK Excel.Sheet.8 "\\\\ibnbs003\\piaprojections\\2005 Budget\\Budget
Book\\2005 Excel Budget Book.xls" "Inv by Region & BU!R9C3" \a \t}
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site:
http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
"0013" wrote in message
...
No, I'm definitly getting it as text. Here is the field code
{ LINK Excel.Sheet.8 "\\\\ibnbs003\\piaprojections\\2005 Budget\\Budget
Book\\2005 Excel Budget Book.xls" "Inv by Region & BU!R9C3" \a \t }
"Jezebel" wrote:
Press Alt-F9 to display field codes. Your link field should look
something
like this:
{ LINK Excel.Sheet.8 "C:\\My Documents\\Temp\\Book1.xls" MyCell \t }
Where MyCell is the name of the cell you want (assuming you've named
it --
otherwise use SheetName!CellRef). The \t switch says you want plain
text,
not an image of the cell containing the value, which seems to be what
you're
getting at the moment.
"0013" wrote in message
...
I'm having a problem with pasting links from excel to a word document.
I'm
using Office 2003
I have a budget in Excel and I'm putting together an executive summary
in
word. I want to link all of the numbers in word to the excel
workbook.
For example, I want to write:
"Expenses in the Americas are xx%."
where the "xx" is a number linked from excel.
I copy the cell that has the number in excel, go to word and choose
paste
special. I then select the paste as link option and choose
unformatted
text
from the list box.
This works fine except that in addition to the number, additional
spaces
are
also inserted. I can delete these, but they come back when I update
the
link. So the sentence ends up looking like:
"Expenses in the Americas are xx%."
How do I get a link to just the number and not the extra spaces?
Thanks in advance for any help.