This worked perfectly once I figured out the step I was doing wrong. Thanks
for your help.

"Per Jessen" wrote:

Hi

Maybe this will help you:

CurDate = Day(Date) & Month(Date) & Right(Year(Date), 2)
WBname = "done" & CurDate & ".xlsx"

Regards,
Per

On 13 Okt., 23:01, aileen wrote:
I need to use a workbook name in a macro but the name of the workbook changes
daily with the date. e.g. done101308.xlsx today will be done101408.xlsx
tomorrow. Is there a way to use a workbook name in a macro but have the part
of the name that is the date automatically change with the computer date?