+ Reply to Thread
Results 1 to 11 of 11

Hyperlink - PDF(specific page)

  1. #1
    Forum Contributor
    Join Date
    12-26-2008
    Location
    India
    MS-Off Ver
    2007
    Posts
    122

    Hyperlink - PDF(specific page)

    Hi,

    Is there any solution to hyperlink from excel to a PDF(specific page).

    To better describe, lets say in cell A1, I enter text as "Link" and right click and select "Hyperlink" and further under "Existing File or webpage", I select the PDF document. So how would I point to the desired page(say page10)

    Any help?

    Vinod

  2. #2
    Forum Contributor
    Join Date
    12-26-2008
    Location
    India
    MS-Off Ver
    2007
    Posts
    122

    Re: Hyperlink - PDF(specific page)

    Any solutions guys. I was expecting some replies from moderators...

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Hyperlink - PDF(specific page)

    Moderators aren't obliged to know the answer. I don't think you can hyperlink to a specific page in a pdf
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  4. #4
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Hyperlink - PDF(specific page)

    i think it depends where its stored. is it on your pc?
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  5. #5
    Forum Contributor
    Join Date
    12-26-2008
    Location
    India
    MS-Off Ver
    2007
    Posts
    122

    Re: Hyperlink - PDF(specific page)

    Martin,
    PDF file is on my desktop.

  6. #6
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Hyperlink - PDF(specific page)


  7. #7
    Forum Contributor
    Join Date
    12-26-2008
    Location
    India
    MS-Off Ver
    2007
    Posts
    122

    Re: Hyperlink - PDF(specific page)

    Thanks martin

  8. #8
    Registered User
    Join Date
    08-16-2010
    Location
    Ankara
    MS-Off Ver
    Excel 2007
    Posts
    2

    Red face Re: Hyperlink - PDF(specific page)

    Quote Originally Posted by martindwilson View Post

    I'm not good enough in excel and I have very limited information about macros in excel. Could you please help me about how can I use this macro in the given link? Please step by step

    Thanks,

    PS: I have learned how to add this macro to excel, however, it gives an error message:

    Compile Error
    User-defined type not defined

    and the part "objIE As New InternetExplorer" is highlighted...
    Last edited by eros_1983; 08-16-2010 at 09:27 AM.

  9. #9
    Registered User
    Join Date
    08-16-2010
    Location
    Ankara
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Hyperlink - PDF(specific page)

    Anybody has any idea?

  10. #10
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Hyperlink - PDF(specific page)

    To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

    Doing this will ensure you get the result you need!

  11. #11
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Hyperlink - PDF(specific page)

    To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

    Doing this will ensure you get the result you need!

+ 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