View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Silencer116 Silencer116 is offline
external usenet poster
 
Posts: 8
Default Excel - Date comparision in VBA

uh that´s not quite what i mean.

i mean like, every day there is a logfile created with the today´s
date.
these files will remain as they are not automatically deleted.

I want a macro to delete logfiles that are older than 7 days, resulting
in that there are always only 7 existing logfiles, from today to 7 days
back.

so when a logfile doesn´t compare with one of these 7 logfiles, it
should be deleted