Reference Single Excel Value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jacob - 23 Mar 2004 21:46 GMT

I need to reference (via a Word field) data in a cell in
an Excel worksheet. I've tried the {Link} field but this
pulls in the entire sheet. I just need the text from one
of the cells. Any ideas?

Thanks, Jacob

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 24 Mar 2004 01:33 GMT

In Excel, select the Cell and Copy it to the Clipboard. Then in Word,
select Paste Special from the Edit Menu and check the Link box.

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

>I need to reference (via a Word field) data in a cell in
> an Excel worksheet. I've tried the {Link} field but this
> pulls in the entire sheet. I just need the text from one
> of the cells. Any ideas?
>
> Thanks, Jacob

Reply to this Message

Jacob - 24 Mar 2004 15:42 GMT

Thanks Doug!

>-----Original Message-----
>In Excel, select the Cell and Copy it to the Clipboard. Then in Word,
[quoted text clipped - 8 lines]
>
>.

Reply to this Message