VBA Userform: Display PDF file and reflect it's contents to the worksheet

Inddon

New Member
Joined
Aug 26, 2020
Messages
2
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Hello There,

I am looking to do the following:
1. Create a Userform:
-add a Userform ListBox item: where it would populate all pdf files from a given directory
-add a Userform PDF display item: Next to the Listbox, display the content of the PDF file
2. On click of a listbox row, display the PDF file
3. On Button Click: copy all the contents of the displayed PDF file
4. Paste it in a worksheet


My environment is as follows:Using VBA Editor, I enabled the below References:Added the Additonal Control:
-Adobe Reader DC
-Windows 10
-MS Excel 2016, 32 bit
-Adobe Acrobat Browser Control Type Library 1.0
-Acrobat Access3.0 Type Library
-AcroBrokerLib
-Adobe Acrobat DC Browser Control Implementation
-Adobe PDF Reader


In the Userform, when I click on the Toolbox - pdf control it gives an error "Element not found" (attached actial screenshot of the rror and reference & controls):
PDF Display in USerorm Error.jpg


I have attached the sample workbook for your reference.

Could you please guide as how this can be achieved using VBA with the actual code and which references are needed?

Thank you & regards,
Don
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Watch MrExcel Video

Forum statistics

Threads
1,112,516
Messages
5,542,163
Members
410,550
Latest member
ganeshsamant
Top