Copy a worksheet and rename with todays date

[SOLVED]

Hi All,

Aim
To create a macro / VB code for my excel workbook which will copy the "template worksheet" and rename the copy as todays date. I would like the date to be in DDMM format.

I have been able to find a VB which will allow me to create a new sheet and re-name it as DDMM but unsure how to adapt it.

Current Code:

Please Login or Register  to view this content.

Hello batchy,

Change "Template" in the code to the name of your worksheet.

Please Login or Register  to view this content.

Thanks Leith.

I have amended both codes which prevents additonal sheets being created. Eg it will only create one sheet for the day.

I have posted the below incase anyone is intrested.

Please Login or Register  to view this content.