Results 1 to 3 of 3

Thread: To setup a hyperlink to external pdf file page only in Microsoft Excel

  1. #1
    Join Date
    Jan 2012
    Posts
    59

    To setup a hyperlink to external pdf file page only in Microsoft Excel

    I created a 100-page PDf file from scanned pages . Now I would like to create a hyperlink in excel to jump to specific page in this document . I tried the simulate this when working with Word when creating a bookmark and using the hyperlink function which refers to the bookmark. Can anybody help ?

  2. #2
    Join Date
    Mar 2011
    Posts
    542

    Re: To setup a hyperlink to external pdf file page only in Microsoft Excel

    Forget hyperlinking A mate and I solved this exact problem using a bit of VB (about which I personally know nothing):
    1. Enter the file name as a url (?) in the cell you want to hyperlink from, followed by the page reference in this format : file:\\\[filepath]#page=[page number]. eg: "file:\\\c:\documents\test.pdf#page=2"
    2. Create a macro and edit it by stepping into it:
    Code:
    Sub pdfpglink()
    Worksheets("Sheet1").Activate
    Shell ("C:\Program Files\Internet Explorer\iexplore.exe " + ActiveCell.Value)
    End Sub
    3. Close the VB editor and assign the macro a shortcut key, eg, ctrl-z Activate the link by selecting the cell and then pressing the shortcut key. This works on my Vista 32bit and 64bit machines, running office 07, but note that on 64bit vista i could only get it working using 32bit iexplore, so your file path is .../program files (x86)/ ... Don't know why, that's just part of the joy of 64bit vista. My mate reckons we can take a similar approach using the adobe reader .exe using the shell command [full path of acrobat reader exectuable] " /a page=[page#] [full path of .pdf file] but I am yet to get that working. Now the only thing I need to do it to fine tune it so that iexplorer opens the .pdf in a larger window.

  3. #3
    Join Date
    May 2011
    Posts
    448

    Re: To setup a hyperlink to external pdf file page only in Microsoft Excel

    You can try the following. When you adding the pdf reference link in Excel sheet then try to add the #page=[page number] at the end of the link. So when you click it, it will take you that page only. Or else there is a code which can help you. Try the below vbcode.
    Code:
    Sub OpenPDFpage()
        Dim myLink As String
        Dim TargetPage As Double
        Dim objIE As New xxxbrowsernamexxx
        myLink = "locationoffile/nameofile.extension" 
        TargetPage = anypagenumber
        With objIE
            .Navigate myLink & "#page=" & TargetPage
            .Visible = True
        End With
    End Sub

Similar Threads

  1. Replies: 3
    Last Post: 31-12-2013, 10:36 AM
  2. Stop external IP to redirect to setup page of router
    By --MasseySian-- in forum India BroadBand
    Replies: 3
    Last Post: 06-09-2012, 01:32 PM
  3. Excel is only printing half page in Microsoft Excel
    By (Cowherd) in forum MS Office Support
    Replies: 2
    Last Post: 17-02-2012, 04:31 PM
  4. Replies: 3
    Last Post: 01-02-2012, 07:45 PM
  5. Replies: 2
    Last Post: 25-01-2012, 06:10 PM

Tags for this Thread

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
  •  
Page generated in 1,711,617,209.15778 seconds with 17 queries