Hi,

Am new to VB.

Invoices in the form of PDF will be scanned to our database. These Invoices will be then recorded in SAP ERP Pakage. But, before this could be done i need to list all the invoices with Invoice no, Invoice Date, Invoice Amount, Quantity of the goods/services provided, Description on the Invoice for reconciliation to excel sheet.

Invoices will be some were around 1000 to 1500 or even more.

Now, i need VB Code which pulls data from the invoice in PDF format like Invoice no, Invoice Date, Invoice Amount, Quantity of the goods/services provided, Description on the Invoice for the quantity sold, to excel sheet.

These invoice in PDF format will be downloaded to a directory.

Can this be done.

Please help me ASAP

Regards
Ranjan

Ranjan .. there are two things you can try

1. Use Acrobat API to search and extract contents (you need to check out with Adobe Acrobat www.adobe.com)

2. If the PDF is in text format (if you can open the PDF in notepad and can read the text clearly), you can read the PDFs as Text files and use some sort of Regular Expressions to extract your data

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)