PDF Hyperlinks to open in a browser instead of Reader or Professional

[Blueridge227]

I have hyperlinks to PDF documents in a directory(C:\acrobat files\test.pdf) I would like to be able to open the pdf to a specific page.(c:\acrobat files\test.pdf#page=2) I realize that adding the #page= will not work from excel 2007.(it just opens to page 1 regardless)
#page= seems to only work when used in a web browser(InternetExplorer).

So my question is, can I use VBA so that all my pdf links will open in a browser? This will enable the #page= function on the end of my hyperlinks.

 

[Warship]

Try:

Sub OpenPDFpage()
    Dim IE As Object
    Set IE = CreateObject("InternetExplorer.Application")
    With IE
    .Navigate "c:\acrobat files\test.pdf#page=2"
    .Visible = True
    End With
End Sub

 

[Blueridge227]

Thank you for your reply.
The problem is I have over 3000 hyperlinks in my column and can't write the path name(C:\Acrobat Files\test.pdf) for every one. Is there code that will set the default app to IE whenever any link is clicked on?