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: