ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I give a hyperlink of TOC of Word in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/20748-how-do-i-give-hyperlink-toc-word-excel.html)

Hatti

How do I give a hyperlink of TOC of Word in Excel
 
I am trying to give an hyperlink in the excel sheet, which refers to a
particular section of TOC in a word file.

Dave Peterson

I'm not smart enough to know the answer to my first question (and I'm too lazy
to test!):

Can you put a bookmark in your MSWord's TOC?

If yes...

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

Both worked when I just put a word bookmark in the body of my document.

Hatti wrote:

I am trying to give an hyperlink in the excel sheet, which refers to a
particular section of TOC in a word file.


--

Dave Peterson


All times are GMT +1. The time now is 01:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com