I have Adobe Reader DC on my PC and am trying to import data from a pdf file to Excel.
The following code using Shell opens the pdf file but I cannot activate it as I want to copy data from it to Excel using SendKeys.
varPdf = Shell("C:\Program Files (x86)\Adobe\Acrobat Reader DC\Reader\AcroRd32.exe " & _
"C:\path to file\Vod.pdf")
AppActivate varPdf
I will appreciate it if someone can let me have some code to make this work. The only references to Adobe that show in Tools/Refs are
Adobe Acrobat Brower Control Type library
Adobe Reader File Preview Type Library
Acrobat Access 3.0 Type Library
AcroBrokerLib
In desperation I have selected them all to no avail!
Best regards
Spike
AdChoices