| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Modification Time Update | Excel Worksheet Functions | |||
| Modification of a .CSV file | Excel Discussion (Misc queries) | |||
| Excel file modification date | Excel Discussion (Misc queries) | |||
| Testing Time /Date stamps of Files | Excel Programming | |||
| Testing Time /Date stamps of Files | Excel Programming | |||
Threaded Mode
