View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default Is there a way to create a program in excel to compare files?

Hi Bruce,
Simple answer don't use Excel for this. In fact I cannot see why you would
want to?

Some form of CRC tool and comparator is probably the answer , have a look at
the following link...

http://www.prestosoft.com/ps.asp?page=edp_examdiffpro

Cheers
Nigel

"bruce" wrote in message
news:7TSvc.37539$pt3.8849@attbi_s03...
I have no problem doing a DIR *.jpg /s templist.txt type of thing. (I

have
been playing with DOS since DOS 1.x!!!!) I can even import that into

Excel.
What I then want to do is to do a bit by bit compare on the files that

have
the same size. This is the part I do not know how to do.
I could even figure out how not to delete from certain directories (I

think)
I am not sure if I could also put a preference together for which
directories would have a "preferred" delete from over a different
subdirectory

Thanks

Bruce

"David" wrote in message
...
Not certain I completely understand what you are trying
to do, but you can write your directories to a file from
DOS, Dir tofilelist. Been a while since I have done
this and I only got the immediate directory list. Maybe
someone can remeber how to get the drive. Once you get
it, you can open in Excel. Think if you have to you can
append to the to the "tofilelist" file.
-----Original Message-----
I am trying to clean up my drives and am looking for a

way to compare and
delete by my specifications. All of the programs I have

used, either lump
all files and compare by name only, for do not have the

inteligence to allow
me to select the order of dirctories to delete from. I

would also like it
to leave certain subdirectories alone, but use them to

compare to other
files.
Would this God awful slow?


I hope I am making this clear enough...

Thanks


.