LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Delete workbook after 30 days ...

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Delete entire row if older then 365 days Pas Excel Discussion (Misc queries) 2 April 4th 10 10:13 PM
Need to pull <=14 Days, <=30 Days, 30 Days from a date column Ken Excel Discussion (Misc queries) 3 October 23rd 09 12:53 AM
How to Delete a Range in Closed Workbook (to Replace Delete Query) [email protected] Excel Discussion (Misc queries) 1 March 8th 06 10:10 AM
how do you delete a workbook Bob Excel Discussion (Misc queries) 2 October 3rd 05 12:18 AM
Delete workbook after say 30 days ... Susanne[_2_] Excel Programming 6 January 26th 04 12:57 PM


All times are GMT +1. The time now is 10:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"