How to open a specific page of PDF document from Excel hyperlink?

When you link a cell to a PDF file, normally, you will go to the first page of the PDF file when you click to open the hyperlink. If you need to directly jump to a specific page of the PDF file by clicking the hyperlink, this article may do you a favor.

Open a specific page of PDF document from Excel hyperlink with VBA code

Open a specific page of PDF document from Excel hyperlink with VBA code

Please do with the following steps to finish this job:

1. Enter the file path, name, and page number as a URL in the cell you want to hyperlink, like this:

file:\\\C:\Users\DT168\Desktop\PDF file\Excel add-ins.pdf#page=10, see screenshot:

Note: You should change the file path, name and page number to your need.

2. Then hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window.

3. Click Insert > Module, and paste the following code in the Module Window.

Sub linkpdfpage()
Worksheets("Sheet1").Activate
Shell ("C:\Program Files\Internet Explorer\iexplore.exe " + ActiveCell.Value)
End Sub

4. Then select the cell which locates the file path and name you have inserted, and press Run button to run this code, see screenshot:

5. The specific page of the PDF file will open in Internet Explorer. See screenshot:

Demo: Open a specific page of PDF document from Excel hyperlink