Save a the same workbook but add a variable number at the end

Hi Swade,

I usually append this to my filename:

 Format(Now(), "yyyymmdd_hhmmss")

Does that suit your needs?
Regards,
Rick