# Thread: how to open specific page in pdf Thanks: 0 Likes: 0

1. ## how to open specific page in pdf

iam looking for a formula or vba in excel which will be easy to access to open specific page in pdf

i have 64 bit adobe Acrobat professional 8

2. ## Re: how to open specific page in pdf

Try this, changing the Acrobat.exe (or Adobe Reader) path and PDF file name as required.
Code:
Const cAdobeReaderExe As String = "C:\Program Files (x86)\Adobe\Acrobat 11.0\Acrobat\Acrobat.exe"

Public Sub Open_PDF_At_Page()

Dim PDFfile As String

PDFfile = "C:\path\to\PDF document.pdf"

AdobeCommand = " /a ""page=2=Open Actions"" "

End Sub

3. ## Re: how to open specific page in pdf

Its Working fine but every time i have to change page number in code

is it possible to get it by using cell reference or function because lot of page links are there for individual cells?

i have to give cell reference to each cell
Ex:
A1=10

10th page need to open

4. ## Re: how to open specific page in pdf

Code:
    AdobeCommand = " /a ""page=" & ActiveSheet.Range("A1").Value & "=Open Actions"" "

5. ## Re: how to open specific page in pdf

Originally Posted by John_w
Try this, changing the Acrobat.exe (or Adobe Reader) path and PDF file name as required.
Code:
Const cAdobeReaderExe As String = "C:\Program Files (x86)\Adobe\Acrobat 11.0\Acrobat\Acrobat.exe"

Public Sub Open_PDF_At_Page()

Dim PDFfile As String

PDFfile = "C:\path\to\PDF document.pdf"

AdobeCommand = " /a ""page=2=Open Actions"" "

End Sub
Hi John, I was trying to use this code with my Mac. But its not working there. Any suggestions ?