Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    May 2003
    Location
    48150
    Posts
    6
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Hyperlink to Word (Excel 2002)

    I am looking to link a specific cell in excel to a specific PAGE in a word document. Excel help is of no use. Any suggestions?

  2. #2
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlink to Word (Excel 2002)

    In Excel 97, I did it by opening the Word doc and inserting a bookmark (then save the file),
    Then in Excel I inserted a Hyperlink indicating the file in the top box and the bookmark name in the bottom box.
    I will go find Excel 2002 to see if it works the same there.

    Chuck
    Chuck Reimer
    I'm from the Government and I'm here to help...

  3. #3
    3 Star Lounger
    Join Date
    Mar 2003
    Location
    Beddau, Mid Glamorgan, Wales
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlink to Word (Excel 2002)

    I have 2000 not 2002, however:

    In Excel - select the cell and COPY.

    In Word - select the appropriate page and EDIT/PASTE SPECIAL/PASTE LINK and select either FORMATTED TEXT or WORKSHEET OBJECT according to your preferences.

    Changes to the Excel cell will be reflected in Word.

    Tony.
    Regards,

    Tony
    [s] [/s]
    www.SylviArtist.com

  4. #4
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlink to Word (Excel 2002)

    Sorry,
    It was easy to create a hyperlink in Excel 97 to bring the user to a bookmark in Word, but I cannot figure out how to do it in Excel 2002.
    It would seem they have improved the process...........

    Chuck
    Chuck Reimer
    I'm from the Government and I'm here to help...

  5. #5
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlink to Word (Excel 2002)

    It's the same mechanism in EXcel 2002, but Excel issues an error message if I try to select a bookmark in the document.

    Looking at the exact wording of the Help for Create a hyperlink, I'd say that it was not intended to be able to create a hyperlink to a Word bookmark from an Excel 2002 woeksheet.

    Have not tried this in Excel 97 or Excel 2000.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Hyperlink to Word (Excel 2002)

    When entering or editing the hyperlink, enter # after the file name and then the name of the bookmark in the Address box:

    C:WordTest.doc#MyBookmark

  7. #7
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlink to Word (Excel 2002)

    Hans,
    That works llike a charm! I tried many switches (, ; / /b etc) but never thought of #.
    I also looked in the Excel help, -right.......

    Thanks again,
    Chuck
    Chuck Reimer
    I'm from the Government and I'm here to help...

Posting Permissions

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