Add Date Stamp to VBA Code

Good afternoon,

I need to add something to the code below that will save the file in the code to the desired location but with a date stamp at the end of the file name, can anyone assist me with this?

Please Login or Register  to view this content.

Thanks in advance

DJ

Please Login or Register  to view this content.

Excellent Thank you,

Just on another note, will the workbook automatically run at the same time every day if the work book is consistently open, or do i need to add a timer or something?