Comparing two excel files

[jplank]

I'm trying to write a macro that will compare all cells in two excel files. The files are, for the most part identical, with only one or two different cells. They both contain a series of tabs that are identically named (names are things like "scenario", "results", etc.). I want to be able to compare the "results" tab in one file to the "results" tab in the second file. I found some code here: http://stackoverflow.com/a/5388488 but I'm having trouble adapting it to loop over each of the tabs in my worksheets. Can anyone point me in the right direction as to how to achieve this?

[patel45]

You are too vague, what do you mean for compare ? attach a sample file

[jplank]

By compare, I mean determine if cell A1 on tab "results" for File1 is equal in value to cell A1 in tab "results" for File2...and then repeat for all cells on all sheets in the file.