+ Reply to Thread
Results 1 to 4 of 4

How to link from excel cells to specific position within word documents ?

  1. #1
    ComeMon!
    Guest

    How to link from excel cells to specific position within word documents ?

    Hi,

    I want to link excel worksheet to particular word document position
    such that when I click on hypertext link inside the worksheet cell, it
    will direct link me to particular paragraph of corresponding .doc file
    e.g. 3rd paragraph of page 10 of .doc file.

    I only find menu option to link from worksheet cell hypertext link
    defined to .doc file which by default directs me to start of .doc
    file.

    Could anyone help me on this problem ? Is extra programming
    unavoidable in this case ?

    :{

  2. #2
    Jean-Guy Marcil
    Guest

    Re: How to link from excel cells to specific position within word documents ?

    ComeMon! was telling us:
    ComeMon! nous racontait que :

    > Hi,
    >
    > I want to link excel worksheet to particular word document position
    > such that when I click on hypertext link inside the worksheet cell, it
    > will direct link me to particular paragraph of corresponding .doc file
    > e.g. 3rd paragraph of page 10 of .doc file.
    >
    > I only find menu option to link from worksheet cell hypertext link
    > defined to .doc file which by default directs me to start of .doc
    > file.
    >
    > Could anyone help me on this problem ? Is extra programming
    > unavoidable in this case ?



    In the Word document insert a bookmark (Insert > Bookmarks...) at the
    location where you want the hyperlink to jump to. Let's say you call it
    "ComeHere"

    Create the hyperlink in Excel. Then right click on it to edit it.
    You will see the path and file name of the Word document, right at the end
    of this, type the following (Without the quotes):
    "!ComeHere"

    That should do it. It does on my system...

    --
    Salut!
    _______________________________________
    Jean-Guy Marcil - Word MVP
    jmarcilREMOVE@CAPSsympatico.caTHISTOO
    Word MVP site: http://www.word.mvps.org




  3. #3
    ComeMon!
    Guest

    Re: How to link from excel cells to specific position within word documents ?

    "Jean-Guy Marcil" <no-spam@leaveme.alone> wrote in message news:<#aFbx03KFHA.3340@TK2MSFTNGP14.phx.gbl>...

    Tks Jean-Guy! It tested work so far. However, I found the linkage only
    worked when I specified absolute path for the corresponding hyperlink.
    Excel will complain can't open file if I use relative path.

    :p

  4. #4
    Jean-Guy Marcil
    Guest

    Re: How to link from excel cells to specific position within word documents ?

    ComeMon! was telling us:
    ComeMon! nous racontait que :

    > "Jean-Guy Marcil" <no-spam@leaveme.alone> wrote in message
    > news:<#aFbx03KFHA.3340@TK2MSFTNGP14.phx.gbl>...
    >
    > Tks Jean-Guy! It tested work so far. However, I found the linkage only
    > worked when I specified absolute path for the corresponding hyperlink.
    > Excel will complain can't open file if I use relative path.


    Post this particular issue in an Excel group, maybe Excel behaves
    differently with regards to hyperlink paths...

    --
    Salut!
    _______________________________________
    Jean-Guy Marcil - Word MVP
    jmarcilREMOVE@CAPSsympatico.caTHISTOO
    Word MVP site: http://www.word.mvps.org




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1