Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hey all,
I got this problem. Every day i have a Macro creating a logfile, that contains the date of today. Like "Test" & Cstr(Date) & ".txt". This works okay and stuff. But now i would like to have a logfile that is 7 days or older; deleted. That made me creating the following: ExpiredDate = Date - 7 Expired = Date = ExpiredDate this would result in: Kill "H:/Test" & Cstr(Expired) & ".txt" But this doesn´t seem to work.. Could someone help me? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Text string comparision within excel | Excel Discussion (Misc queries) | |||
date comparision | Excel Discussion (Misc queries) | |||
date range comparision on a criteria | Excel Discussion (Misc queries) | |||
Date comparision | Excel Discussion (Misc queries) | |||
help with date comparision | Excel Programming |