View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Peter Clancy Peter Clancy is offline
external usenet poster
 
Posts: 2
Default Testing modification time of file

What can I say? Genius, it works like a charm.
Thanks

"Die_Another_Day" wrote:

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.