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

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

Hi Bob,

I was treated like a useless female and told not to
delete files automatically as I would get myself into
trouble ... like one day I might need a file.

If it is not possible to write a kill macro for 30 day
files as I have described then why not say so ...

Thanks in advance,

Susanne
-----Original Message-----
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


.

Hi Susanne
we're all just carefull (nothing to do with male/female). Just lost too
much data myself due to automatic programs :-)
But now to your problem:
1. Though it is possible to write a macro to delete all files older
than 30 day this will require more VBA coding than just copy and paste.
In addition to make this code work, Excel has to run and I would
consider such kind of code dangerous (e.g., loss of data due to code
errors, etc.).
2. This was the reason I suggested some other stand-alone tools with
much more flexibility and easier user-interface (together with backup
functionality, etc.).

So I'd look into some shareware/open source programs which will do this
job. You can schedule these programs to run automatically at a specific
time (lunch break, etc.) and perform their deletion tasks

Regards
Frank


Susanne wrote:
Hi Bob,

I was treated like a useless female and told not to
delete files automatically as I would get myself into
trouble ... like one day I might need a file.

If it is not possible to write a kill macro for 30 day
files as I have described then why not say so ...

Thanks in advance,

Susanne
-----Original Message-----
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


.