Auto delete a workbook

[soodaarti21]

hi there... i need a help i am circulating a report to couple people in my office every month which contains lot of macros and formulas.... if i want that after 30 days the old file gets deleted automatically so that they can easily save my new file without changing its name or overwritting it..... pls help if it is possible!!!

 

[Domski]

Have a look here: http://www.vbaexpress.com/kb/getarticle.php?kb_id=540

Dom

 

[soodaarti21]

thaks it helps....

 

[soodaarti21]

One more thing i wanted to ask.... if I want to get the workbook deleted exactly after 30 days from today then what should i do???