If you go back to Cetin's post, that command will do the trick where cfilename would equal pam.xls
oExcel.OBJBOOK.workSHEETS("Grade Sheet").Saveas(cFileName)
>I am using the following code:
>
>ObjBook.Worksheets["Grade Sheet"].COPY()
>
>How can I automatically tell the system to save the new workbook as pam.xls? I see I need to purchase your book really soon!!!!
>
>Thanks in advance for your assistance.
>
>Do you have a web site?
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