TOC and link to Word
 

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

TOC and link to Word
 

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

TOC and link to Word
 

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

TOC and link to Word
 

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

TOC and link to Word
 

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


"David McRitchie" wrote:

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

TOC and link to Word
 

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

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


"David McRitchie" wrote:

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