+ Reply to Thread
Results 1 to 3 of 3

Duplicate File Finder (Checksum project-Stage 3)

  1. #1
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Duplicate File Finder (Checksum project-Stage 3)

    While the Checksum Project Stage 2 is not 100% complete yet, I consider it stable enough (thanks to help from LJMetzger) to move onto the next stage - a Duplicate File Finder.

    See v3.01 attached.

    On the tab marked Stage3 there are two buttons.

    The first button is a shortcut to the File/Folder Lister from Stage 2. On the Form that appears, select the Custom Search option, Folders = No, and Files = Yes. (Up to you whether you choose to filter the file extensions or not).
    It should produce a workbook that contains a range of file paths (FullName) in Column A.

    The second button prompts for a workbook to import. Choose the workbook that you created using button 1. It should output a workbook containing a list of the duplicate files and their respective checksums.

    1. The duplicate code is something I threw together. I'd appreciate suggestions on how to improve it. (It's in Module1)
    2. The tool needs testing. I'd be grateful if anyone could point out any unhandled errors and how to trigger them. (Apart from the ones I'm aware of - see comments in sub CalculateFileCRC32Checksum_ListImport in module t_ref_CRC_Checksum_140403 )


    UPDATES: I don't have time to clean the current version for uploading but just a quick note:
    * There is a minor error in the Duplicate module. It should set variant to vbnull not erase variant as it currently appears.
    * Also I have rethought how Stage 3 will work. It is stupid to checksum all the files all over again just to find the duplicates. Instead the current (unreleased) version accepts a file list with checksums (from Stage 2 Step 2) and then checks for duplicates on this imported list. Much faster.
    * I want to clear Stage3 fast so I can move onto future stages...
    Attached Files Attached Files
    Last edited by mc84excel; 04-07-2014 at 08:31 PM. Reason: Add Update
    *******************************************************

    HELP WANTED! (Links to Forum threads)
    Trying to create reusable code for Custom Events at Workbook (not Application) level

    *******************************************************

  2. #2
    Valued Forum Contributor
    Join Date
    08-06-2013
    Location
    Detroit, Michigan
    MS-Off Ver
    Excel 2013
    Posts
    671

    Re: Duplicate File Finder (Checksum project-Stage 3)

    So I realize this was posted a little while ago, but just to let you know, I'm working on making my own duplicate file finder. Mine is very raw right now, but if you want to share ideas, let me know.
    1. Include a sample workbook with an example of the result you want
    2. Use [CODE] and [FORMULA] wrappers for your VBA code or excel formulas
    3. If your question has been answered, mark the thread as SOLVED and click on the "Add Rep" star to thank whoever helped you.

  3. #3
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Re: Duplicate File Finder (Checksum project-Stage 3)

    Quote Originally Posted by k64 View Post
    So I realize this was posted a little while ago, but just to let you know, I'm working on making my own duplicate file finder. Mine is very raw right now, but if you want to share ideas, let me know.
    I've sent you a PM

+ 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. [SOLVED] File Lister (CRC32 Checksum Calculator project-Stage 2)
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 04-07-2014, 08:26 PM
  2. [SOLVED] Duplicate Finder problem
    By holmwood in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-02-2014, 08:15 AM
  3. Replies: 1
    Last Post: 06-01-2013, 01:27 AM
  4. Duplicate data finder/remover
    By dawsonsoo in forum Excel General
    Replies: 5
    Last Post: 07-14-2009, 03:54 PM
  5. Part Finder Project
    By sighlent1 in forum Excel General
    Replies: 3
    Last Post: 04-30-2009, 10:09 AM

Tags for this Thread

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