previous day
Yes, XL knows several tricks to simulate everyday operations, it's worth
while to try them!
Regards,
Stefi
€˛tigoda€¯ ezt Ć*rta:
that easy eh?
thanks!
"Stefi" wrote:
Format(Date-1, "ddmmm")
Regards,
Stefi
€˛tigoda€¯ ezt Ć*rta:
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
|