Auto-Schedule Generator Excel Macro
The Schedule Generator Excel Macro is a project I worked on with two other
CS students as a sample of Microsoft Excel macros, for a Professional Communications
class. The project grew into a handy utility to generate a weekly
schedule sheet of classes, and it has saved me much time and hassle ever
since. I've decided to make it freely publicly available so that
other people may use it as well.
2. Screen Shot
THE AUTO-SCHEDULE GENERATOR EXCEL MACRO IS PROVIDED "AS IS" WITHOUT
WARRANTY OF ANY KIND. MARK ROTH DISCLAIMS ALL WARRANTIES, EITHER
EXPRESSED OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS
FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MARK ROTH BE LIABLE FOR
ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL,
LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MARK ROTH HAS BEEN
ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW
THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL
DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.
4. Usage Instructions
To use the Auto-Schedule Generator Excel Macro, you must have the following:
To use the macro, download the spreadsheet by right-clicking the link in
the next section and selecting "Save Link As..." Save the spreadsheet
in a folder on your hard drive and open it in Microsoft Excel*. Once
the spreadsheet is open, Excel* may warn you that there are Macros in the
spreadsheet. You must click "Enable Macros" for this spreadsheet
Microsoft Excel* 95 or later
At least 48KB of free hard drive space
Once the spreadsheet is downloaded and opened in Excel, simply fill
in your class name, building, room, days, time from, and time to for each
of your classes, type in a title for the spreadsheet, and click the "Generate!"
button. The schedule will be generated. Click the print icon
or select Print from the File menu to print your schedule.
To reuse the spreadsheet, click the "Reset Sheet" button. This
will clear out all the information you have entered and allow you to start
To download the Auto-Schedule Generator Excel Spreadsheet, right click
on the following link, and select "Save Link As." Choose any folder
on your hard drive or a floppy or zip disk. To run the macro, extract
scheduler.xls from the zip file, and load up Microsoft Excel* and open
the scheduler.xls file (be sure to select "Enable Macros"). See previous
paragraph for more details.
6. Final Notes
This program was created by Mark Roth, a student at the Rochester Institute
of Technology in Rochester, NY. If you have any questions, comments,
suggestions, or bug reports, please do not hesitate to contact me.
My contact information is as follows:
* Microsoft Excel is a registered trademark of Microsoft Corp.
Last Updated: December 6, 1998