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

Hello Tigoda,

Try...
ActiveWorkbook.SaveAs Filename:="C:\test\" & Format(Now() - 1, "yymmdd")
& ".xls"


Les Stout

*** Sent via Developersdex http://www.developersdex.com ***

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

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

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