Function OpenPDFpage(myLink As String, TargetPage As Double)
Set objIE = CreateObject('InternetExplorer.Application')
With objIE
.Navigate myLink & '#page=' & TargetPage
.Visible = True
End With
End Function
In excel enter a formula
in column C
=IF(D9='Y', OpenPDFpage(E9, F9) , '-')
D, Y or N
E, Full path and file name
F, Page no
thanks,
GH 17 Jan 2013,11: 44
I too was trying to link to an internal PDF page and tried the HYPERLINK function. It does not link into an internal page. And I am using v2010.
However, if the Hyperlink dialog box [not the =HYPERLINK() function] is used to create the link, it DOES work.
AW 15 Jan 2013,17: 24
Using #page= does not work if the file is stored locally, at least it's not working for me. From what I've read online using #page= only works if you're hyperlinking to a URL
Richard Chapman 15 Jan 2013,13: 51
In v2010, using #page=5 as the target in the hyperlink formula works without a macro.
=HYPERLINK('E: \testgary.pdf#page=5')
This poem has not been translated into any other language yet.
I would like to translate this poem