| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link table from excel to word using word VBA | Excel Discussion (Misc queries) | |||
| VB Help WORD/EXCEL LINK | Excel Discussion (Misc queries) | |||
| Link or embed into Word? | Excel Discussion (Misc queries) | |||
| How do I link a certain number to a certain word? | Excel Worksheet Functions | |||
| how do i link a word to a colour so everytime i type the word gre. | Excel Discussion (Misc queries) | |||
Hybrid Mode
