Hi All,

I am comparing 2 lists..
List 1 is my manually entered list.
List 2 is collected using VBA.
The lists are 2 do with my movie collection, has worked very well to date but i want to make it so List 2 checks List 1 then only displays the files not listed or that do not match for whatever reason.

Below is my code i have so far that works but is very very slow to compare..
Please Login or Register  to view this content.
Once this seems to work a bit better i will then be looking into having the Lists work in a way that compares files from my Backup HDD and the NAS.
Then it will list the differences of the 2 locations and allow me to modify if needed.
Once i'm happy i click a macro that will delete old files off HDD and copy across from NAS in it's place..

Any help to speed up the Compare stuff would be great as a starter..

Oh there are approx 2000 files it goes through..
The section which lists the files works very quickly, but the compare and clear contents part takes about 15mins which is a long time..

Cheers in advance..