title: VBA date and Save
body: <p>I am trying to build a macro that place the current date (12/15/2012) in one of the cells of the sheet (say A1), saves the sheet as 12.15.2012 then places yesterday's date(12/14/2012) in the same cell, saves the sheet and so forth. How do I do that? Thank you so much!</p>