View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Delete workbook after 30 days ...

So, enlighten us, what was wrong with the answers supplied there?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Susanne" wrote in message
...
Hi all,

I asked this question before. I have a template that
creates a number of workbooks each day that analyse the
stockmarket. These become obsolete at the end of the
trading day and relevant data transferred to a monthly
workbook.

As these daily workbooks build up and clog up the works I
need a macro that will automatically delete these after
30 days.

I have the date in cell AD1 and need a macro that will
kill files 30 days old.

Thanks in advance,

Susanne