I have several hundred PDFs which each contain a summary paragraph that I need to transfer to an Excel spreadsheet. The spreadsheet is a table of the individual PDFs, so each summary will go on a new row in the table.

Is there any way to accomplish this with VBA? If not, are there any other recommended alternatives?