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

ScheduAll Report Automation - Karl Rosengren - Winter 2010

ScheduAll is a useful tool for scheduling resources. Unfortunately, it does not do a very good job of analyzing the way those resources are used. By exporting the data to Excel, the data can be analyzed more effectively. But there's a problem. The export from ScheduAll is in a printable format that does not lend itself to analysis or charting.

This code will take the data from ScheduAll and covert it into a data table that can then be made into a pivot table for easier analysis. It will also automatically filter the data and create a chart.

So the code covers saving new files, opening files, copying data, creating new workbooks and sheets, creating pivot tables, customizing pivot tables, creating charts and even has a user form for control.

Note: because of the sensitive nature of the data I can not include it here. But the code is instructional as a reference.

No comments:

Post a Comment

Blog Archive