set bk = Activeworkbook
bk.worksheets(5).Copy

ActiveWorkbook.Saves "file_" & _
bk.worksheets(3).range("g10").text & ".xls"

--
Regards,
Tom Ogilvy

"Rhonda Johnson" wrote in message
...
i need to copy sheet(5) to its own workbook and then save
that wb as "file_" & worksheets(3).range("g10").text
& ".xls", is this possible

thanks so much