This post written by Daniel Ferry, an Excel MVP, chronicles how he and Beth Melton, a fellow MPV, designed a Gradebook template in Excel that makes teachers’ lives a whole lot easier. Several teachers, however, wanted to make the template even more useful. They asked us whether the template could batch print all student progress reports at once. To tackle this task, we knew recording a new macro wouldn’t cut it. I needed to write a VBA script. Here's how I did it. ...( read more Read...