Hello,
I have written some macros to convert PDF files to text arrays or to Excel sheets. They work fast and efficiently. Of course each one depends on the exact format of the original PDF and the desired layout of the final Excel sheet. The basic code converts the PDF file into a text file, then the macro simply uses Excel and VBA techniques to handle the text fields.
A few words about me: I'm developing VBA code for more than 15 years and I'm a trainer for Excel and VBA (all levels) for 12+ years. As you can guess, I have created a plethora of VBA macros of almost any kind and difficulty level, for both training purposes and business.
Looking forward to hear from you,
Kind regards,
Chriskerpini