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

Wednesday, April 11, 2012

Stat Parser

The organization that I work for has several large databases that recently underwent a change that needs to be closely monitored. These statistics are included in a daily html report. To monitor the effect that these changes had on the databases we need to open each html file and look at 2 specific statistics. To really identify any effect of the changes I would need to be able to graph the changes.

To solve this problem I designed this project that uses VBA to cycle through all files in a directory and search each file for the correct statistics, adding them to an excel spreadsheet and graphing the results. To accomplish this I had to use different references(one for the file system object and one for regular expressions)

Stat Parser(Report)
Stat Parser
Example Files

No comments:

Post a Comment

Blog Archive