Results 1 to 6 of 6
  1. #1
    Lounger
    Join Date
    Jan 2001
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Linking to Bookmarks in Word Documents

    How do I link to a bookmark in a Word Document from and Excel spreadsheet. I've looked in MS Help to no avail.

    Thx in advance

  2. #2
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking to Bookmarks in Word Documents

    Try adding
    #bookmark
    to the hyperlink.
    (Where bookmark is the actual name of the bookmark)

    (Works in Word/Excel 2K)

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Baltimore, MD, Maryland, USA
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking to Bookmarks in Word Documents

    Suppose your word file was c:myfile and you wanted to go to the myBookmark01 withing that file? I tried insrting a Hyprlink "c:myfile.xls myBookmark01" but it did not work. I am using XL 97.

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Linking to Bookmarks in Word Documents

    Hi,
    I think you need to change the hyperlink to point to:
    C:myfile.doc #myBookmark01
    (I'm assuming it's myfile.doc not myfile.xls?)
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking to Bookmarks in Word Documents

    If it works, it would be:
    <pre>c:myfile.xls#myBookmark01
    </pre>

    Note - no spaces. The 'screen tip' displays as "c:myfile.xls - myBookmark01"
    Not sure if you can do it in XL97 though, but gotta worth a try.
    Try the attached.
    Attached Files Attached Files
    • File Type: xls x.xls (18.0 KB, 4 views)

  6. #6
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking to Bookmarks in Word Documents

    When you choose Insert/Hyperlink from Excel, having tracked down the document, you can type the Bookmark name directly in the Named Location area. The Tooltip doesn't show the Bookmark name, but it does work.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •