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
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