TOC and link to Word

[Guest]

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]

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")

 

[Guest]

Dave

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

 

[David McRitchie]

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.

 

[FredN]

Thanks. This was very helpful but now I want to up the ante and place two
hyperlinks in one cell. Possible? Thanks again.

 

[Shane Devenshire]

Hi,

There are programs for that, but Excel does not handle this. You could
attach a macro to the hyperlink and have the macro prompt you for with
hyperlink(s) to open.

If this helps, please click the Yes button

cheers,
Shane Devenshire

Thanks. This was very helpful but now I want to up the ante and place two
hyperlinks in one cell. Possible? Thanks again.