VBA code: link to a specific page of pdf file: Sub linkpdfpage() Worksheets('Sheet1').Activate Shell ('C: Program Files Internet Explorer iexplore.exe ' + ActiveCell.Value) End Sub 4. 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. Enter the file path, name and page number as a url in a cell that you want hyperlink from as 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. Open a specific page of PDF document from Excel hyperlink with VBA code Please do with the following steps to finish this job: 1. Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |