Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



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

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 21-01-2012
Member
 
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 ?

Reply With Quote
  #2  
Old 21-01-2012
Member
 
Join Date: Mar 2011
Posts: 536
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.
Reply With Quote
  #3  
Old 21-01-2012
Member
 
Join Date: May 2011
Posts: 444
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
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "To setup a hyperlink to external pdf file page only in Microsoft Excel"
Thread Thread Starter Forum Replies Last Post
Microsoft Excel file open error " Not a valid single file web page" Whelan MS Office Support 3 31-12-2013 09:36 AM
Stop external IP to redirect to setup page of router --MasseySian-- India BroadBand 3 06-09-2012 01:32 PM
Excel is only printing half page in Microsoft Excel (Cowherd) MS Office Support 2 17-02-2012 03:31 PM
After inserting hyperlink it is not working in Microsoft Excel Chachhi MS Office Support 3 01-02-2012 06:45 PM
How to setup hyperlink of file name and path through Excel via VBA Purujeet MS Office Support 2 25-01-2012 05:10 PM


All times are GMT +5.5. The time now is 07:11 PM.