Excel - Import data from online PDF

October 2017



Issue


Does anyone know if it is possible to import/update data from an online PDF file, into Excel?

Basically, it is needs to be able to automatically refresh data when changes are made to the online PDF.

Solution


An Excel VBA routine that uses an open source PDF to text conversion utility and then imports data from multiple PDF files based on matching rules into a structured Excel table can be downloaded here
Published by aakai1056. Latest update on December 14, 2011 at 03:53 AM by aakai1056.
This document, titled "Excel - Import data from online PDF," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).