Does anyone know if it is possible to import pdf data from the internet into excel? Or do I need a special adobe acrobat program to do so?
Basically, I need to be able to automatically refresh data connected to pdf's online so that I can use that data in pivot tables. Examples of data I might use are coffee or sugar prices. Would I have any luck?
I have just created 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. You can download and use this for free at http://www.business-spreadsheets.com/forum.asp?t=884.
I use EDI Link Connect. It will convert a PDF (like an invoice or Purchase Order) into a file that can be used with Excel, Quickbooks or Simply Accounting. It was designed for people who do more than about 2 hours/month of inputting data from a PDF. Works great for converting Invoices & Purchase Orders into Excel files or compatible with Quickbooks & Simply Accounting. Here is an article about it for more info: