That also saves the original workbook as pam.xls with the "Grade Sheet" worksheet active.

The only thing that seems to work is:

ObjBook.Worksheets["Grade Sheet"].COPY()

I just need to know how to automatically tell the system what to save it as.