LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default File modified date problem

I'm trying to write some code to determine if two copies of a file
stored on two different drives are identical. I thought this would be
fairly easy by checking the file length and the modified date. In doing
this I found that if I copy a file to a different location on the same
drive, the modified date stays the same. But if I copy the file to a
different drive the modified date is changed by a second or two. I've
tried this numerous times with different variations and always get the
same results - copy a file to the same drive, same modified date; copy
it to a different drive and you now you have different modified dates.
I see the same results whether I check it using FileDateTime or
DateLastModified. In Windows Explorer you don't notice this because it
doesn't show the seconds.

So now my questions...
Does this happen to everyone else too?
Why would Microsoft do this? (I know - a stupid question.)
How can I determine if files on different drives are the same when the
modified date changes even when the file hasn't been modified? I can't
rely on file length alone because it is possible to change a file and
have its length remain the same. I can't do a comparison of the file
contents because there are many files to check and it would probably
take forever.

Any suggestions would be greatly appreciated.
Tony

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula for file modified date Pastel Hughes Excel Discussion (Misc queries) 3 April 4th 08 06:23 PM
Date modified changes when file not saved BAC Excel Discussion (Misc queries) 5 January 3rd 08 12:49 PM
Last modified date of a linked file tjc Excel Discussion (Misc queries) 8 August 31st 07 04:30 PM
date file modified Matthew Excel Discussion (Misc queries) 2 October 11th 06 06:52 PM
Get the date a file was modified JustinP Excel Programming 2 September 5th 06 04:54 AM


All times are GMT +1. The time now is 06:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"