I need to import 2000 PDF files to Excel. I tried using a VBA macro and "Shell". I can start the PDF reader but don't know how to do a cnrt+A and Cntl+C to select all and copy.

Any hints?