View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Die_Another_Day Die_Another_Day is offline
external usenet poster
 
Posts: 644
Default Testing modification time of file

Whoops, that's 20 days. use this instead:
How about:
If (Now - (20/24)) < FileDatetime(strFilename) Then
'Do Stuff
End If

Charles

P.S. In VBA 1 in a date format = 1 day, you want 20hrs or 20/24ths of a
day.