How to bulk transfer text from PDF to Excel

[slavrenz]

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?

[macropod]

This may be possible - provided you have Adobe Acrobat Pro. Version 8 is available as a free download. The 'may be' reflects the fact that what can be achieved depends on how reliably one can programmatically locate the data you require. For an idea of what can be done, see:
https://www.msofficeforums.com/excel...pdf-excel.html
https://www.msofficeforums.com/excel...-end-file.html