These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Tuesday, April 13, 2010

Martech Computers Invoice Scraper


Situation

The Martech invoice scraper is a macro enabled word document that programmatically scrapes invoices and inserts all the scraped information into an Access database. Martech Computers is a small IT and computer shop in the metro Atlanta area. The company has been in business since the early 90s and has invoices written in standard Microsoft Word Documents. Unfortunately for the company, the rate of business has not allowed them to implement a more sophisticated method of building invoices or the ability to look at customer and service history.

Solution

The Martech invoice scraper hopes to solve that by allowing the user to specify the directory where older invoices are located and programmatically going through each document and scraping the invoices for customer, invoice, and sale items information and putting them into an Access database.


Invoice Scraper Word Document

Invoice Database

Sample Invoices


Program Details and Overview


No comments:

Post a Comment

Blog Archive