Example 2: Using Adobe Application object for Acrobat Pro So, when you use objects you can be sure you are interacting with the correct window regardless of whether it is active or inactive. API uses an object to identify and target a specific window. The better solution is always to go with the API approach as you can see in the next example. It is not always possible to guarantee that the active window is the intended window. So, while the macro is running if you accidentally make another window active, it will not give the desired results. Note that SendKeys can be unreliable mainly because it literally sends the command (keys) to the active window.
ADVANCED EXCEL VBA PROGRAMMING PDF PDF
When you run this code, the PDF file will get focus and search string will be highlighted, like this 'Type the search string in the find box that opens 'The second argument "true" implies that Excel will wait for the keys to be processed 'Send "CTRL + F" keys to the opened PDF to invoke find within that file
While DateDiff("s", waitTime, Now) & amp amp amp amp gt 2 'Wait time for a couple of seconds for the PDF file to fully load 'Your search string - case-insensitive, as in actual PDF search 'if your Excel and PDF are in separate folders 'Make sure to provide a complete path to the PDF here You can follow along the comments in the code. Then we will use the SendKeys function to first invoke search (using Ctrl + F), type the search string and send “enter” key to perform the actual search operation. In this we will simply open the PDF file specified, using FollowHyperlink. Example 1: Using SendKeys in Acrobat Reader We will look at two examples, one that works with Acrobat Reader and a second that should be used if you have Acrobat Pro licensed version. In this article we will see how you can search for a string in a PDF file and highlight it using Excel VBA.
0 kommentar(er)
