opening new workbook and saving sheet

I am trying to write code which copies the activesheet (called "Data"), opens a new workbook, pastes the data into it and closes the new sheet as "sales 2008" followed by the date. What I have at the moment is:

Please Login or Register  to view this content.

Unfortunately it's not working. It opens a new workbook (called book1) but then tries to close my existing workbook

You've got some errors in there and appear to be calling Workbooks("sales 2008.xls") for some reason. You just need:

Please Login or Register  to view this content.

Richard

Try this

Please Login or Register  to view this content.