so far i have the following bit of code:

ActiveWorkbook.SaveAs FileName:="C:\test\" & Format(Date, "ddmmm") & ".xls"

this works nicly saving the thing with todays date (I.e 17 Oct)

what i need is to save it with yesterdays date and i have no idea how to
-1day from the format

please help