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