#1
|
|||
|
|||
How to use vba to open a pdf file to a page you want?
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 |
|
Similar Threads | ||||
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 |
HELP! Computer crashed, no recovery file, old versions, etc and file was open for over 24 hours! | matthew.coppedge | Word | 2 | 04-07-2016 09:01 PM |
Formula to open external file with specific program (like open with) | pemartins | Excel | 16 | 02-24-2014 11:39 PM |
excel cannot open the file .xlsx because the file format or file extension is not val | 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 |