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

I have not found any CRC checkers that will allow me to control the deleted
files well enough (from certain subdirectories not to delete files from but
still use the files to compare against) or controlling which subdirectories
have the preferred deletion.

I am looking at ExamDiffPro now, but from what I see, it does not do it
either.

The best I have seen so far is "CloneMaster" If it just had a option to the
directory controls, it would be great!

All I need to know is how to read a binary file (which should not be to big
of a deal) and then how to compare. Since we ARE talking BINARY files, I am
NOT sure how to do this in Excel.....
The rest, I know how to do. Excel is the method I would use as I am more
familiar with it than any other langage, and it would allow me to sort the
directories and other manipulations

Thanks

Bruce

"Nigel" wrote in message
...
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


.