December 5, 2014

Open PDF File Using Excel VBA

We can open a PDF file from within MS Excel using VBA.

Watch the video below:

You can also view the video on YouTube.


As you can observe opening a PDF file from within Excel using VBA requires a single line of VBA code.

Sub openPDF()
ThisWorkbook.FollowHyperlink “C:\Users\takyar\Desktop\test-save.pdf”

End Sub

Download a sample file by clicking on the Excel icon:


3 thoughts on “Open PDF File Using Excel VBA

  1. what will be the code to open and print if you have multiple PDF file with single folder

Comments are closed.