Opening PDF in Acrobat READER DC via VBA in Excel
I have a list of PDF files in MS Excel. I want to open & then close the files in Acrobat Reader.
I do Not want to edit the files, only Open & Close.
I have the VBA Reference: "Adobe Reader File Preview Type Library" selected.
I should be able to use Early Binding.
Could someone fill in the missing code so I can use Acrobat Reader.
Thank you in advance. I've spent hours trying to figure this out!
Sub TestFilesPDF()Dim sFile As String
Dim sFile as string
'Early Binding
Dim PDFApp As Acrobat.CAcroApp 'Acrobat Reader HELP
Dim PDFDoc As Acrobat.CAcroAVDoc 'Acrobat Reader HELP
'Note:
'dllFile = "C:\Program Files (x86)\Adobe\Acrobat Reader DC\Reader\AcroRd32.dll"
'exeFile = "C:\Program Files (x86)\Adobe\Acrobat Reader DC\Reader\AcroRd32.exe"
'Uses Early Binding to open Acrobat Reader
Set PDFApp = "" '<< Help
Set PDFDoc = "" '<< Help
With wsFileList
sFile = .Cells(2, 3).Value
'Open File
PDFDoc.Open sFile, vbNormalFocus
'Close File
PDFDoc.Close
End With 'wsFileList
'Release memory
AcroApp.Exit
Set AcroDoc = Nothing
Set AcroApp = Nothing
End Sub
