View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default can I link my Excel Cells to a table in a Word Document

Hi,
try Dave Peterson solution

If I want a link in Excel that points at a specific location in an MSWord
document, I'd add a bookmark to that document and use one of these:

(Insert|hyperlink style)
C:\MY DOCUMENTS\WORD\MyDoc.DOC#bkmk01
Or
=hyperlink() style:
=hyperlink("C:\MY DOCUMENTS\WORD\MyDoc.DOC#bkmk01")



"Dr. Darrell" wrote:

If I choose Text, then the value in my cell won't update when the value in
the Word Doc is changed.

Am I correct with this statement?

"Eduardo" wrote:

Hi,
you can do paste special and choose text

"Dr. Darrell" wrote:

I need to go in the other direction. I need the value whic is in the word
document to appear in my excel file.

When I try to do your steps, the row of the table gets inserted as an object.

"Eduardo" wrote:

highlight the range I need in Excel, copy, go to
Word, select Paste-Special-Microsoft Excel Object, and then check the circle
that says Paste-Link.


"Dr. Darrell" wrote:

I would like to link some cells in an Excel File to some Cells in a Word
Document's Table.

Is there an effectict way to do this?

The Word Document is a living Document which has values changing
periodically, and I would like my cells in the Excel File to change along
with them.

Darrell