I am semi-new to vba and I have been trying to get a PDF file to open via a macro on excel, but am having some trouble having it work. The code is not producing any errors, but Acrobat is not opening. I edited out the file path since it contained personal information. I also have the “Adobe Acrobat 10.0 Type Library” referenced. Any help would be greatly appreciated!
Sub Opener()
Dim AcroApp As Acrobat.AcroApp
Dim Part1Document As Acrobat.AcroPDDoc
Set AcroApp = CreateObject("AcroExch.App")
Set DocPath = CreateObject("AcroExch.PDDoc")
DocPath.Open ("....")
Set AcroApp = Nothing
Set DocPath = Nothing
MsgBox "Done"
End Sub
2