Help with saving a workbook as yesterdays date.

[justchris]

Basically i have a macro to save my workbook as the date. The only problem is i dont update it till after 12. I need it to save the workbook using yesterdays date. Any help would be great



Thanks
Chris