Solved: create a copy

[philfer]

When you right click a tab in a workbook you can create a copy of this sheet.

Is there a way to do this in VBA and then copy and paste the values in the new worksheet and then prompt the user to save the new workbook and suggest a filename (the date in the format 06.01.2008, where the report date is currently in the format 6/1/2008). And then save the new workbook and return to the workbook you started from.

All this has to be done from the existing workbook you started out from

[Simon Lloyd]

[VBA]Activesheet.copy [/VBA] will create a copy of your worksheet in a new workbook use
[VBA]
ActiveWorkbook.SaveAs ActiveSheet.Name & Format(Date, "dd-mm-yyyy")
[/VBA]to save the workbook as the sheet name plus the date