View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
AA2e72E[_2_] AA2e72E[_2_] is offline
external usenet poster
 
Posts: 93
Default Is there a way to create a program in excel to compare files?

If you have WORD and your files are text files, create two documents in respect of each file: he first contains the 'source' and the second the 'target'

Open either the 'source' or the 'target' in WORD and then use : Tools | Track Changes |Compare Documents. This will alter the document you have open (so don't save it or you'll overwrite the original). The active document has vertical bars in the left margin wherever there are differences. Text which has been struck through indicates text that has been removed; text that is underlined shows new text. The comparison is text sensitive.