Hyperlink to specific page in a pdf

[bwjohnson1]

I have read through a lot of discussions on this topic but haven't had any
luck yet.

I have tons of pdf files that are hundreds of pages and would like to be
able to create hyperlinks to specific pages in these docs. I want to keep
them as pdf files. I have created bookmarks in the pdf files but when I try
to hyperlink from excel to those bookmarks, I get this error message:

"Certain file formats, such as XML, do not support bookmarks so you cannot
create a hyperlink to a bookmark in a file that does not support bookmarks.
You can either hyperlink to the file without any bookmarks, or change the
file format so you can insert bookmarks into and hyperlink to the bookmark."

This confuses me because the file isn't an XML, its a pdf. Can anyone help
me out?

Thanks,
Brian

 

[Mike H]

Hi,

AFAIK this can't be done the way you are trying but here's a UDF that does
it provided you happy to open with Internet explorer.

You would call this using the full path and page number

=GoToPDFpage("c:\Somefile.pdf",4)

Function GoToPDFpage(Fname As String, pg As Integer)
Set IE = CreateObject("InternetExplorer.Application")
With IE
.Navigate Fname & "#page=" & pg
.Visible = True
End With
End Function
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.