+ Reply to Thread
Results 1 to 8 of 8

Comparing Multiple Word Documents

  1. #1
    Forum Contributor
    Join Date
    05-23-2013
    Location
    Ohio
    MS-Off Ver
    Excel 2013
    Posts
    259

    Comparing Multiple Word Documents

    Hi Everyone,

    I'm currently sorting through a folder where many copies of the same documents were placed. I have been using the Compare feature in MS word but it is damn tedious.

    Is there a macro I can use that will run the compare feature and open the file picker so that after running the macro the only two clicks I need to make are the 2 files to compare? For some files there are up to 8 copies and I need to rule out which are the same vs have differences (and many are not named exactly the same, but have (#) after them- if there were a way to automate comparison of all files with the same name up to the first parentheses that would be amazing!))

    I know this is a relatively simple macro conceptually but my brain is broken at the moment.

    Thanks in advance for all your assistance!

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Comparing Multiple Word Documents

    You might start here: https://www.excelforum.com/word-prog...ml#post5323754
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Forum Contributor
    Join Date
    05-23-2013
    Location
    Ohio
    MS-Off Ver
    Excel 2013
    Posts
    259

    Re: Comparing Multiple Word Documents

    Hi Macropod that was very helpful! I did try searching but none of what I searched for was in that thread I guess.

    A few questions:

    Is the revised document just combining everything into one? For instance I am looking through documents that have verses/stanzas and I'm trying to determine which are identical so I can just delete them. Of the ones that are not identical, I do not want to necessarily just combine the content that isn't identical as some may be older drafts or have only one or two elements I want to keep.

    Honestly I would be happy if this just told me Yea or Nay on identicalness or not. I could burn through the files and delete the duplicates then go back and compare the differences. Open to suggestions, and thank you so much for your quick reply!

  4. #4
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Comparing Multiple Word Documents

    If you want to compare whether files are the same, you could use any of the plethora of Windows file comparison utilities. You could delete all the duplicates so that you then need only compare the differences within Word.

  5. #5
    Forum Contributor
    Join Date
    05-23-2013
    Location
    Ohio
    MS-Off Ver
    Excel 2013
    Posts
    259

    Re: Comparing Multiple Word Documents

    My problem is I don't know which are duplicates (content wise) and I can't assume. The MS Word Compare feature is slow and tedious to use on a large number of files since it can only compare 2 things at a time and its generally terrible.

    Your script accomplishes the first thing I was hoping for (easy/quick automation of the filepicker that I can tie to a command button), but really all I need beyond that is to know if the docs are the same, not to necessarily have them combine into a new doc (or, if they do combine into a new doc, if the combined text could be different colors so I can see what was unique between them, etc. and then auto delete the old).

  6. #6
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Comparing Multiple Word Documents

    Quote Originally Posted by liquidmettle View Post
    My problem is I don't know which are duplicates (content wise) and I can't assume.
    Which is precisely why I suggested:
    If you want to compare whether files are the same, you could use any of the plethora of Windows file comparison utilities. You could delete all the duplicates so that you then need only compare the differences within Word.
    Quote Originally Posted by liquidmettle View Post
    The MS Word Compare feature is slow and tedious to use on a large number of files since it can only compare 2 things at a time and its generally terrible.
    Word's file comparison utility does an excellent job of comparing everything - including formatting.
    Quote Originally Posted by liquidmettle View Post
    Your script accomplishes the first thing I was hoping for (easy/quick automation of the filepicker that I can tie to a command button), but really all I need beyond that is to know if the docs are the same
    which is exactly what a file comparison utility does.
    Quote Originally Posted by liquidmettle View Post
    not to necessarily have them combine into a new doc (or, if they do combine into a new doc, if the combined text could be different colors so I can see what was unique between them, etc. and then auto delete the old).
    which is precisely what Word's document comparison tool can be used for.

    One way or another, you're going to have to eyeball each non-exact duplicate.

  7. #7
    Forum Contributor
    Join Date
    05-23-2013
    Location
    Ohio
    MS-Off Ver
    Excel 2013
    Posts
    259

    Re: Comparing Multiple Word Documents

    I don't mind eyeballing the unique versions, but Word's compare feature, while functionally excellent, is awful to use- the sheer amount of clicks and mouse movements necessary make it a non-starter for anything more than a handful of documents at one time. At least half the time it doesn't remember the folder I last pulled from and I still have 400 some files to go through (those 400 being composed of groups of duplicates from 3 to 10ish files). Yes, if I only had a small number of files I'd have just used it, but I've also had a rather bad day, on top of a rather bad few months (I've had about 2-3 full, don't need to think about work at all days off in the last 80) and this thread now just feels like arguing. Which I don't want to be doing.

    I appreciate your initial help, I guess I'll muddle through and hope I can figure it out.

    Thank you.

  8. #8
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Comparing Multiple Word Documents

    I have already pointed you to a macro to simplify the comparison tool's use. If you're concerned to ensure the macro always looks in a particular folder, simply specify that folder via the two lines coded as:
    Please Login or Register  to view this content.
    For example, to ensure the dialogs open in a 'Poems' sub-folder of your 'Documents' folder:
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Generate Multiple Word Documents from Multiple Excel Files
    By TellerFarsight in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-05-2018, 12:58 PM
  2. Choose multiple Word-Documents via UserForm TextBox and combine them to Master Word-Doc
    By ODeveloper in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-15-2015, 09:25 AM
  3. Split a single word document into multiple word documents
    By CaptainCool in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-10-2014, 03:31 AM
  4. Batch Compile 100+ multiple word documents into a single word document
    By JamesFrames8 in forum Word Formatting & General
    Replies: 4
    Last Post: 04-03-2014, 08:49 PM
  5. How to create multiple word documents using data from multiple excel files.
    By Milan Kotus in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-14-2013, 12:07 PM
  6. Inserting multiple excel files into multiple word documents
    By lwaldron in forum Word Programming / VBA / Macros
    Replies: 11
    Last Post: 10-02-2012, 05:34 AM
  7. comparing 2 documents in word
    By EXCELLEANER in forum Word Formatting & General
    Replies: 1
    Last Post: 11-25-2010, 03:14 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1