I am trying to use VBA to read some text from a pdf.
I read that I need to reference the library, Adobe Acrobat 10.0 Type Library. So I downloaded the Acrobat DC SDK for windows from download page. However I have looked through the files but I can't find the Adobe Acrobat 10.0 dll. Where can I find this dll?
22 Answers
You can download it here: The Acrobat X SDK
Once you have unzip file, you will find a bunch of folders. You want to drill down to this folder:
\Acrobat 10 SDK\Version 1\InterAppCommunicationSupport\Headers And look for the acrobat.tlb file there.
Add it to your references in the VB Editor by using Browse.
Once added, it will show up as Adobe Acrobat 8.0 Type Library - Which seems odd, since it's in a zip file named Acrobat 10 SDK, but that seems to do it.
I had the Adobe Acrobat 10.0 Type Library in one of my Excel sheets but could not locate it in any other Workbook so I saved the one it was in as a different book and copied all my data to the new book. The Adobe 10.0 Type Library worked just fine then.
So you might see if you have the Library in another book.