![]() |
|
#1
|
|||
|
|||
![]()
There is a pdf file name and its hyperlink on the excel form saved on the computer, how to write vba code to open the pdf file to the specified page. The specified page number can be entered in the form of an input box, thank you!
|
#2
|
|||
|
|||
![]()
.
Untested here : https://www.exceltrainingvideos.com/...ing-excel-vba/ |
#3
|
|||
|
|||
![]() Quote:
Sub openPDFFileXPage() Dim oShell As Object Dim nPage As Integer Set oShell = CreateObject("WScript.shell") nPage = Application.InputBox("page£º") With oShell .Run """C:\Users\N. Gregory Mankiw - Principles Of Economics (2021, Cengage Learning) - libgen.lc.pdf""", 5, False .Run """C:\Users\N. Gregory Mankiw - Principles Of Economics (2021, Cengage Learning) - libgen.lc.pdf""", 5, True .SendKeys "^+N" .SendKeys VBA.CStr(nPage) .SendKeys "{ENTER}" End With Set oShell = Nothing End Sub how to modify this code let the code automating add the file? C:\Users\N. Gregory Mankiw - Principles Of Economics (2021, Cengage Learning) - libgen.lc.pdf like the file link address added in a dialogue box to select on pdf file the code add the link after run""? thx |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Every Folder I open goes into File Explorer but when I click on a file it won't open | bird dog | Word | 3 | 10-08-2019 10:03 AM |
![]() |
matthew.coppedge | Word | 2 | 04-07-2016 09:01 PM |
![]() |
pemartins | Excel | 16 | 02-24-2014 11:39 PM |
![]() |
teddysika | Excel | 1 | 11-22-2012 06:06 AM |
Possible to open each page of file in a different window? | Fran71 | Word | 2 | 04-27-2012 07:25 PM |