Open Pdf Poem by Alvinzor Flores

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')