PDA

View Full Version : Solved: create a copy



philfer
01-06-2008, 09:46 AM
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
01-06-2008, 09:55 AM
Activesheet.copy will create a copy of your worksheet in a new workbook use

ActiveWorkbook.SaveAs ActiveSheet.Name & Format(Date, "dd-mm-yyyy")
to save the workbook as the sheet name plus the date