Is it possible compare two excel files, using vba?

Question

I would like to know if using VBA I can compare two similar excel files and shows the differences highlighting the background of cells or rows with different colors.

score 4 · Accepted Answer · edited Sep 24 '14 at 06:39

4

Loop through all the cells and make simple comparison, and highlight (change background color) cells that did not match.

edited Sep 24 '14 at 06:39

Jean-François Corbett

37,420
30
139
188

answered May 20 '10 at 08:04

Marek

687
6
13

1

@Cornelius: Have you actually tried this "looping through cells"? If you have, then your code is probably still running... – Jean-François Corbett Oct 03 '11 at 08:34

Is it possible compare two excel files, using vba?

1 Answers1

Linked