Link Word and Excel through hyperlink?

[Rich]

Hi;

I am trying to create a link in a Word table that will
take me to a specific cell on a spreadsheet. Does this
require programming??

I can set up a hyperlink easy enough, but it takes me to
A1 in the spreadsheet, and I can't figure out how to tell
it to go to cell "K33" for example.

Any help would be much appreciated. I thought I had
posted this last week but I can't find it.

Thanks!

 

[Jezebel]

1. Open the target spreadsheet and name the cell you want as your target.

2. In Word, insert the hyperlink to the spreadsheet as normal.

3. Press Alt-F9 to display field codes. Within the hyperlink field, add \l
"TargetName" (that's a lowercase L), so your field looks something like
this:

{ HYPERLINK "C:\\Documents and Settings\\All Users\\Query1.xls" \l
"CellName" }

 

[Rich]

Thanks!

-----Original Message-----
1. Open the target spreadsheet and name the cell you want as your target.

2. In Word, insert the hyperlink to the spreadsheet as normal.

3. Press Alt-F9 to display field codes. Within the hyperlink field, add \l
"TargetName" (that's a lowercase L), so your field looks something like
this:

{ HYPERLINK "C:\\Documents and Settings\\All Users\\Query1.xls" \l
"CellName" }







.

 

[Suzanne]

In Word, how can I link to an Excel "Name", so that Word displays the value "named"?