Sample 1

Each of these files (and the students&rsquo .xls files) must be in the same folder (directory) on your computer to function.

homework.xls – this is the file given to students. A copy of this file must exist in the folder with grade.xls every time the script is run. I forget nearly every time and I get the runtime error to remind me.

grade.xls – this is the file that grades the homework and saves a copy of the students&rsquo data.

answers.xls – the file with the answers.

roster.xls – the file with the names (or other unique identifier) of your students.