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

  • Thread starter Thread starter ComeMon!
  • Start date Start date
C

ComeMon!

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 ?
Click to expand...


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
(e-mail address removed)
Word MVP site: http://www.word.mvps.org
 
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 :
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.
Click to expand...

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

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org
 
Back
Top