Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink to specific page in a PDF file
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 ? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink to specific page in a PDF file
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: 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. Can anyone help? "Tahani" wrote: 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 ? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External hyperlink to a specific page in a workbook | Excel Worksheet Functions | |||
Calling a specific worksheet from a hyperlink in a seperate file. | Excel Worksheet Functions | |||
jump to hyperlink, extract value at specific destination in file | Excel Worksheet Functions | |||
Excel should let hyperlink of PDF jump to a specific page like IE. | Excel Discussion (Misc queries) | |||
Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel |