Linking from Excel Worksheet to a Bookmark in Word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kim Finleyson - 16 Apr 2004 02:08 GMT

Can anyone tell me how to create a hyperlink in an Excel
worksheet that would open a specific Word document at a
specified bookmark within the Word document?

Example: My Excel worksheet includes a cell
referencing "Spec-01". A lengthy Word document contains a
paragraph explaining "Spec-01." I want to add a hyperlink
in the spreadsheet that would open the Word document and
go immediately to the "Spec-01" bookmark without the user
having to scroll down.

Would I need to write some kind of macro to do this, or
is there someway within Excel to specify a certain
location in a Word document? I'm using Word/Excel 2000.

Thanks!
Kim F.

Reply to this Message

David McRitchie - 16 Apr 2004 14:09 GMT

Hi Kim,
There probably aren't that many Word people in this Excel newsgroup,
so perhaps you can answer some questions, and provide more detail.
- Can you link to a bookmark from within another Word document.
- Can you link to a bookmark within a Word document from HTML

Take a look at
http://www.mvps.org/dmcritchie/excel/sheets.htm

Try something like:
http://www.xyz.com/mydocument.doc#bookmark3

I suspect that you can't because I've seen the question go
unanswered.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

> Can anyone tell me how to create a hyperlink in an Excel
> worksheet that would open a specific Word document at a
[quoted text clipped - 13 lines]
> Thanks!
> Kim F.

Reply to this Message

Kim Finleyson - 16 Apr 2004 20:11 GMT

David,

Yes, I can cross-reference a bookmark inside a Word
document to a bookmark in the same Word document, which is
actually an internal hyperlink (you can click on it). I
don't know how to do it from HTML to Word. It's easy to
link from one HTML document to a targeted position in
another HTML document, but I'm trying to jump between
Excel and a targeted position (bookmark) in Word.

Microsoft Knowledge Base has an article that references a
similar subject between Access and Excel/Word: "How to
Programmatically Embed or Link an Object in a Form"
(http://support.microsoft.com/default.aspx?
scid=http://support.microsoft.com:80/support/kb/articles/q1
14/2/14.asp&NoWebContent=1).... However I was really,
really hoping there'd be some code I could embed directly
in my worksheet that would open the Word doc and position
to some pre-selected text.

Well, I will keep looking, and in the meantime if you
think of something, or even think of a creative work-
around, I'd be much appreciative!!!

Thanks,
Kim

(work email: Kim@<no spam>PCSSInc.com

>-----Original Message-----
>Hi Kim,
[quoted text clipped - 36 lines]
>
>.

Reply to this Message

Dick Kusleika - 16 Apr 2004 20:29 GMT

Kim

Go to Insert-Hyperlink and in the File textbox, type:

C:\MyPath\MyWord.doc#MyBkMark

The # followed by the bookmark name sets the SubAddress of the hyperlink.
This worked for me in Excel2000.

Signature

Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

> David,
>
[quoted text clipped - 77 lines]
> >
> >.

Reply to this Message

JE McGimpsey - 16 Apr 2004 20:55 GMT

> Hi Kim,
> There probably aren't that many Word people in this Excel newsgroup,
[quoted text clipped - 10 lines]
> I suspect that you can't because I've seen the question go
> unanswered.

FWIW, I've successfully used exactly that syntax in MacXL v.X. I've not
tried it in XL03, but I'll put it on my list.

XL doesn't read the bookmarks of the Word document, so the anchor
(#bookmark) needs to be entered by hand.

Reply to this Message