Thread
:
Testing modification time of file
View Single Post
#
3
Posted to microsoft.public.excel.programming
Die_Another_Day
external usenet poster
Posts: 644
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.
Reply With Quote
Die_Another_Day
View Public Profile
Find all posts by Die_Another_Day