Linking from Excel Worksheet to a Bookmark in Word

[Kim Finleyson]

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.

[David McRitchie]

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

"Kim Finleyson" <kmp...@hotmail.com> wrote in message news:1d44201c4234f$53cd0470$a501...@phx.gbl...

[Kim Finleyson]

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

>.
>

[Dick Kusleika]

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.

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

"Kim Finleyson" <kmp...@hotmail.com> wrote in message

news:1daf401c423e6$9aa32590$a401...@phx.gbl...

[JE McGimpsey]

In article <O6ujCS7I...@TK2MSFTNGP10.phx.gbl>,
"David McRitchie" <dmcri...@msn.com> wrote:

> 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.

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.