-------------Import PDF Data to Excel Application Instructions----------------
---------Business Spreadsheets: http://www.business-spreadsheets.com----------

Set up instructions:
1. Extract both the Import_PDF_Data.xls and pdfttotext.exe into the same directory as the PDF Files.
2. Open Import_PDF_Data.xls, enter extraction rules and click 'Run Extraction'. Example rules have been entered to run a text import on the test PDF files included.

The program relies on the conversion utility and all PDF files to reside in the same directory as the Excel VBA application.  Text or data to extract are defined in the Control sheet by specifying start text, end text and multiple replacements routines with wildcard support.  This enables flexibility to obtain comparable data from multiple PDF files based on patterns independent of different PDF file structures. Multiple instances of text patterns found within each file are ouput in the order for which they reside in the file. 

As many extraction rules as required can be set in order to create a table of information imported by extraction rule and PDF file name.  Information on how to set up rules is available within the Excel application and the VBA code is open for modification.  

Any improvements or new features to the code are welcome. For more information and support, please see http://www.business-spreadsheets.com/forum.asp?t=884.
