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
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):
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
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):
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
