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.

http://files.gove.net/shares/files/10w/krr6/Rosengren_Karl_-_Final_Project_-_ScheduAll_Report_Automation.xlsm

http://files.gove.net/shares/files/10w/krr6/Rosengren_Karl_-_Final_Project_Description.pdf