ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Hyperlinks to specified bookmark (https://www.excelbanter.com/excel-discussion-misc-queries/241326-hyperlinks-specified-bookmark.html)

Mindy

Hyperlinks to specified bookmark
 
Hi, I am trying to hyperlink a row to a specific book mark in a word
document. I am using the following formula, but it only navigates you to the
document not to a specific bookmark in the document.

Formula used:
=HYPERLINK("[K:\TECHBASE\DHS_Solicitations\BAA09-014]Introduction",
"BAA09-14")

Any Suggestions

Bob I

Hyperlinks to specified bookmark
 
Is the Bookmark name "Introduction" ?

Then use

=HYPERLINK("K:\TECHBASE\DHS_Solicitations\BAA09-014doc #Introduction" )

Mindy wrote:

Hi, I am trying to hyperlink a row to a specific book mark in a word
document. I am using the following formula, but it only navigates you to the
document not to a specific bookmark in the document.

Formula used:
=HYPERLINK("[K:\TECHBASE\DHS_Solicitations\BAA09-014]Introduction",
"BAA09-14")

Any Suggestions



Dave Peterson

Hyperlinks to specified bookmark
 
Saved from a previous post:

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

Mindy wrote:

Hi, I am trying to hyperlink a row to a specific book mark in a word
document. I am using the following formula, but it only navigates you to the
document not to a specific bookmark in the document.

Formula used:
=HYPERLINK("[K:\TECHBASE\DHS_Solicitations\BAA09-014]Introduction",
"BAA09-14")

Any Suggestions


--

Dave Peterson


All times are GMT +1. The time now is 04:08 PM.

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