Open pdf from vba

Somehide hide payroll data in column G? Press F5. Type G1. Look in formula bar while you arrow down through G. Joined Oct 28, Messages 7. Hi tinkythomas ; Code:. Hi Tarkan, where do I place the first line sof code?

I'm receiving a compile error with the code as displayed. Ok, I have now placed the code in a new module and have eliminated the compile error! But the pdf file doesn't open. I have systernals process explorer to monitor whether acobat.

Last edited: Oct 28, JP Board Regular. Joined Oct 27, Messages Try this: Code:. Shell" myShell. Thanks JP, it appeared that my acrobat pro install was corrupt! Although I could open pdf files normally by double clicking Anyway, I uninstalled acrobat pro and installed the latest reader and now I can open pdf's using the followhyperlink method. Not sure what was wrong with the pro install, maybe I will re-install and have another go?

But for now with the reader all appears to be well. Thanks for evryone's help it has been a great help. That's usually the cause when the usual methods of opening PDFs stop working.

Glad to hear it worked out! Hi again, Alternative code example Code:. Asked 3 years, 9 months ago. Active 1 month ago. Viewed 12k times. Improve this question. Community Bot 1 1 1 silver badge. ClydeHopper ClydeHopper 11 1 1 gold badge 2 2 silver badges 6 6 bronze badges. Add a comment. Active Oldest Votes. I have found two solutions to this: The first one is using the built-in Shell function. Open tgtfile End Sub. Improve this answer. Thank you! I tried both and it seems like I must be missing something.

The last one didn't do anything but the first one produced a "file not found" error message. Which following variation is the correct if any? Also, are these slashes facing the right direction?

Shouldn't I be using the backwards slashes? End Function You can then open it with Shell. Chronocidal Chronocidal 6, 1 1 gold badge 10 10 silver badges 25 25 bronze badges. That makes sense but I have to admit that most of that goes over my head. How should the path script portion look if the PDF file is in the same folder as the excel file where the macro will be run? Share 0. Tweet 0. Article Navigation Heading 2 Example.

Heading 2 Example. The picture above shows the window tree of a sample PDF document. Option Explicit 'Retrieves a handle to the top-level window whose class name and window name match the specified strings.

This function does not perform a case-sensitive search. The SendMessage function calls the window procedure 'for the specified window and does not lParenturn until the window procedure has processed the message.

SetForegroundWindow lParent 'Find the handle of the first child window.