Using vba in Excel open a pdf and copy data to Excel

New Here ,
Feb 19, 2021 Feb 19, 2021

Copy link to clipboard

Copied

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

TOPICS
General troubleshooting, How to

Views

37

Likes

translate

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
no replies

Have something to add?

Join the conversation