I have the below excel code that will open Adobe Reader. Then it will open a PDF file, copy data in 1st page and paste it into an excel document.
Somehow I need to figure out the below:
Loop through all PDF files in the directory
Open one file at a time, copy the data in the 1st page...