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
I would be happy to use a Late Binding solution!
I do not want to use FollowHyperlink
Copy link to clipboard
The IAC does not work with Reader
Could you please give an Excel VBA example of the best way to output a PDF file and then open it in Acrobat Reader DC?