Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 25
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
hyperlink to a bookmark in a pdf Lynn Excel Discussion (Misc queries) 0 May 16th 07 01:31 PM
bookmark or hyperlink? swissforestry Excel Discussion (Misc queries) 2 February 22nd 06 06:18 PM
Automatic Bookmark dond Excel Discussion (Misc queries) 1 January 25th 06 10:44 AM
bookmark a chart? me Charts and Charting in Excel 3 August 28th 05 01:23 AM
Hyperlink to a bookmark erik Links and Linking in Excel 1 February 1st 05 12:25 AM


All times are GMT +1. The time now is 10:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"