And with Dave's answer that solved your problem, hopefully you looked up
HYPERLINK Worksheet Formula in your HELP, so
the link would might look something like:
=hyperlink("C:\MY DOCUMENTS\WORD\MyDoc.DOC#bkmk01", "bookmarks")

If you also want to link Excel documents, see
http://www.mvps.org/dmcritchie/excel/sheets.htm

Basically if you can create a link in an HTML document you should
have little problem creating a link in Excel or MS Word.

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Alan" wrote in message ...
Dave

Many Thanks ... searched the posts, but missed that

"Dave Peterson" wrote:

Saved from a previous post:

So you want to add a hyperlink in an excel document that links to a certain
location in an MSWord file?

If I want a link in Excel that points at a specific location in an MSWord
document, I'd add a bookmark to that document and use one of these:

(Insert|hyperlink style)
C:\MY DOCUMENTS\WORD\MyDoc.DOC#bkmk01
Or
=hyperlink() style:
=hyperlink("C:\MY DOCUMENTS\WORD\MyDoc.DOC#bkmk01")

Alan wrote:

I have a TOC in excel that hyperlinks to various documents. This only
provides a broad link to the first page of the document... is there a way I
can link this to individual chapters and headings ??? similar to a toc index
in word ???

Maybe im missing something obvious .. any help would be appreciated

Many Thanks

--

Dave Peterson