Thread: How to link from excel cells to specific position within word documents ?

Hi,

I want to link excel worksheet to particular word document position
such that when I click on hypertext link inside the worksheet cell, it
will direct link me to particular paragraph of corresponding .doc file
e.g. 3rd paragraph of page 10 of .doc file.

I only find menu option to link from worksheet cell hypertext link
defined to .doc file which by default directs me to start of .doc
file.

Could anyone help me on this problem ? Is extra programming
unavoidable in this case ?

:{

ComeMon! was telling us:
ComeMon! nous racontait que :

> Hi,
>
> I want to link excel worksheet to particular word document position
> such that when I click on hypertext link inside the worksheet cell, it
> will direct link me to particular paragraph of corresponding .doc file
> e.g. 3rd paragraph of page 10 of .doc file.
>
> I only find menu option to link from worksheet cell hypertext link
> defined to .doc file which by default directs me to start of .doc
> file.
>
> Could anyone help me on this problem ? Is extra programming
> unavoidable in this case ?


In the Word document insert a bookmark (Insert > Bookmarks...) at the
location where you want the hyperlink to jump to. Let's say you call it
"ComeHere"

Create the hyperlink in Excel. Then right click on it to edit it.
You will see the path and file name of the Word document, right at the end
of this, type the following (Without the quotes):
"!ComeHere"

That should do it. It does on my system...

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org

"Jean-Guy Marcil" <no-spam@leaveme.alone> wrote in message news:<#aFbx03KFHA.3340@TK2MSFTNGP14.phx.gbl>...

Tks Jean-Guy! It tested work so far. However, I found the linkage only
worked when I specified absolute path for the corresponding hyperlink.
Excel will complain can't open file if I use relative path.

:p

ComeMon! was telling us:
ComeMon! nous racontait que :

> "Jean-Guy Marcil" <no-spam@leaveme.alone> wrote in message
> news:<#aFbx03KFHA.3340@TK2MSFTNGP14.phx.gbl>...
>
> Tks Jean-Guy! It tested work so far. However, I found the linkage only
> worked when I specified absolute path for the corresponding hyperlink.
> Excel will complain can't open file if I use relative path.

Post this particular issue in an Excel group, maybe Excel behaves
differently with regards to hyperlink paths...

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org