YesOh i see what you are doing, basically after every new run, in the new run whatever files/folders that are included in the previous run, are removed from the newer run..so basically with each new run it's checking back to see if the file/folder exists or not..if not its keeping the file/folder if it does exists it deletes it from the new run. Am I correct in this reasoning?
I didn't do it that way since if there were 3-4 runs, and THEN the manual de-dup it would get confusingBasically, my code does exactly what your code does except it lists everything first (excluding defined folder paths), selects or highlights duplicate folder paths and then there's a button to remove them...the end result is similar to your code above
Right before each run, the macro knows what the starting data is, and can tell the difference between that 'old' data and the 'new' data being added in the second run to eliminate overlaps from the new data
Finally, I think this is what the function does:
D:\Test\111
D:\Test\222
D:\Test\333
run 1: exclude: D:\Test\111, include: D:\Test\222, D:\Test\333
run 2: exclude: D:\Test\222, include: D:\Test\111, D:\Test\333 (D:\Test\333 removed, because it is already listed from run 1)
Yes
Before:
D:\Test\111
D:\Test\222
D:\Test\333
Run 1: exclude D:\Test\111 from Before
D:\Test\222
D:\Test\333
Run 2: exclude D:\Test\222 from Before
D:\Test\111
D:\Test\333
Result:
D:\Test\222 (from run 1)
D:\Test\333 (from run 1)
D:\Test\111 (from run 2 since 333 was already there)




Reply With Quote