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
|