Hi,

I've a workbook with a few sheets. I want to save one particular sheet to a new workbook with a predefined workbookname that also ends with a date. The code below works fine partly, because instead of saving the particular sheet, it save the whole workbook again with the pre-defined workbookname. What is wrong in my code?

[vba]Sub Sheet_SaveAs()
Sheets("Output").Select
ActiveSheet.SaveAs "C:\Test - Recon_Output_ " & Format(Date, "yyyymmdd")
End Sub[/vba]

Regards,

RM