Results 1 to 14 of 14
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Doc Comparison (WinNT4, Word97)

    I have a directory which contains copies of some documents from each of several other directories, but not all in any particular case.

    Does anyone know of a way to compare the documents with the same names in these directories to see whether they have the same last-edited date? I can't just copy them all across willy-nilly, but I need to check that this directory has the most up-to-date copies of the ones it does contain ...

    Many thanks in advance for any help!
    Beryl M


  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Doc Comparison (WinNT4, Word97)

    The good old XCOPY command (in a Command Prompt window or in a batch file) has a /D option that copies only those files whose source time is newer than the destination time. So I suppose you could create a batch file that does what you want.

    If you want to use VBA, you can use FileDateTime("path-and-filename") to get the date and time a file was last modified.

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Doc Comparison (WinNT4, Word97)

    Hi Hans, thanks for that. XCopy sounds good, but I don't think it would copy only files that already exist there, and are newer than the existing copy, would it?

    The FileDateTime option sounds as though it might have possibilities, I'll have to look into it - trouble is, although we're talking about 200-300 docs here, if I spent too much time working out and writing VBA to check it for me I could probably check the docs manually quite a bit quicker (if rather boringly ...)! <img src=/S/sigh.gif border=0 alt=sigh width=15 height=15>
    Beryl M


  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Doc Comparison (WinNT4, Word97)

    Hi Beryl,

    XCopy with the /D option will copy a source file if
    - There is no corresponding target file
    - There is a corresponding target file, but it is older than the source file.

  5. #5
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: Doc Comparison (WinNT4, Word97)

    You could try using a briefcase to do this. It's a bit buggy, but this is exactly the functionality it is designed to give.

    StuartR

  6. #6
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Doc Comparison (WinNT4, Word97)

    Thanks, Hans, that's what I thought - and of course I don't want it copied unless it's already there, but older!
    Beryl M


  7. #7
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Doc Comparison (WinNT4, Word97)

    Sounds interesting, Stuart; I have to admit I've never used the briefcase - I'm assuming here that it's the thing MS leaves lying around on the desktop unless you say otherwise? - how would I go about setting this up, pls?
    Beryl M


  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Doc Comparison (WinNT4, Word97)

    Beryl, if you open a command prompt window and type

    XCOPY /? | MORE

    You'll get an overview of all possibilities. Another option is /U: Copies only files that already exist in destination. You can combine options, so /D /U will copy only files that already exist in the destination folder, but are older than the source file.

  9. #9
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: Doc Comparison (WinNT4, Word97)

    Briefcase is very easy to use.
    <UL><LI>You can create a new briefcase in any folder by simply right clicking and choosing New > Briefcase, or you can use the one already on the dekstop.
    <LI>Drag documents or folders from a network drive to the briefcase to create a local copy.
    <LI>Edit the document at either location.
    <LI>Open the briefcase and choose Update All to compare document revision dates, you will be presented with a list of modified documents and the direction in which they will be copied.
    <LI>You can override the direction of copy (or skip) for any individual document.[/list]The worst bug is that occasionally you will see that every document in the briefcase claims to have changed at both ends, even though the displayed revision dates are the same. You then have to sort this out manually - sometimes you have to go so far as to delete and recreate the briefcase to fix it. One workaround is to have multiple smaller briefcases to reduce the impact of this problem.

    StuartR

  10. #10
    Plutonium Lounger
    Join Date
    Oct 2001
    Location
    Lexington, Kentucky, USA
    Posts
    12,107
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Doc Comparison (WinNT4, Word97)

    Of course you could always spring some bucks for a copy of Araxis Merge which has many more uses than what you're looking for, but it ain't free, that's for sure. I don't use NT so I don't know if this XP equivalent is available in Explorer in that OS. In XP Explorer you can set the View command to include date created and then run two instances of Explorer, one for each folder.
    Attached Images Attached Images

  11. #11
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Doc Comparison (WinNT4, Word97)

    Hi Al, thanks for the suggestion - unfortunately, since they haven't 'sprung' any 'bucks' even to upgrade from WinNT/Word97, I can't see them being willing to do so for extra bits! Having said that, it would be easy enough to run two standard NT Explorer windows side by side, and since the last modified date is one of the columns available anyway, I would be able to compare the two directories like that.

    In fact that might be the way I have to go in the end!
    Beryl M


  12. #12
    Plutonium Lounger
    Join Date
    Oct 2001
    Location
    Lexington, Kentucky, USA
    Posts
    12,107
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Doc Comparison (WinNT4, Word97)

    Maybe to put a little careful pressure on "them," you could download a 30-day, fully functional copy of Araxis Merge to see if it does what you need to do (wink, wink).

  13. #13
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Doc Comparison (WinNT4, Word97)

    I could, if it wasn't for the facts that downloading unauthorised software is forbidden and being found with an unauthorised .exe file on your machine is grounds for dismissal ...!

    <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Beryl M


  14. #14
    Plutonium Lounger
    Join Date
    Oct 2001
    Location
    Lexington, Kentucky, USA
    Posts
    12,107
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Doc Comparison (WinNT4, Word97)

    Ouch! Forget I said anything.....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •