The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by And then the specific page of the PDF file has been opened with the Internet Explorer, see screenshot:ĭemo: Open a specific page of PDF document from Excel hyperlink Then select the cell which locates the file path and name you have inserted, and press Run button to run this code, see screenshot:ĥ. Shell ("C:\Program Files\Internet Explorer\iexplore.exe " + ActiveCell.Value)Ĥ. VBA code: link to a specific page of pdf file: Sub linkpdfpage() Click Insert > Module, and paste the following code in the Module Window. Then hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window.ģ. Note: You should change the file path, name and page number to your need.Ģ. Enter the file path, name and page number as a url in a cell that you want hyperlink from as this:įile:\\\C:\Users\DT168\Desktop\PDF file\Excel add-ins.pdf#page=10, see screenshot: Please do with the following steps to finish this job:ġ. Open a specific page of PDF document from Excel hyperlink with VBA code 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. 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. How to open a specific page of PDF document from Excel hyperlink?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |