I read your original post too fast and answered too fast, of course the answers you received from others is the correct answer. I have to do exactly what you are doing in one of my apps, so I just slapped myself up side the head, ouch...
>This saves the entire workbook with the "Grade Sheet" as the active sheet. I just need that one sheet saved to another spreadsheet. I do not want the other sheets saved to the new spreadsheet.
Michael Helms
May the Schwartz be with you.<(©¿©)> -- Mel Brooks
"Someday, and that day may never come, you will be called upon to perform a service" -- Vito Corleone
"Live like there is no tomorrow, Dance like no one is watching, Love like you've never been hurt." -- Anonymous
"I'm thinking about joining the campaign for shorter tag lines." -- Me