Wrox Programmer Forums
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 12th, 2009, 02:21 AM
Registered User
 
Join Date: Jan 2009
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default VB Code

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

Last edited by ranjanurs1496; February 12th, 2009 at 02:32 AM..
 
Old February 12th, 2009, 02:27 AM
Friend of Wrox
 
Join Date: Sep 2005
Posts: 812
Thanks: 1
Thanked 53 Times in 49 Posts
Default

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)





Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I write this vb 6 code to work in vb 2008? sanderson Visual Basic 2008 Essentials 3 June 10th, 2008 01:46 PM
VB Code gtjr92 BOOK: Beginning Ajax with ASP.NET 0 July 26th, 2007 08:06 AM
Urgent:hard disk serial code and vb code ivanlaw Pro VB 6 0 July 25th, 2007 04:05 AM
VB: .Exe file, serial code and activation code ivanlaw Pro VB 6 8 July 6th, 2007 05:44 AM
VB Code jdeaver Pro VB Databases 0 January 6th, 2004 05:14 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.