VishalkumarT
04-02-2007, 02:17 AM
Dear Friends
I am searching for a VBA code with which I can compare two (or more, may be) xls files, and generate a resulting file which shows where the data or strings are not equal.
My xls files contain several data in terms of worksheets inside them, so for example, one xls file contains 10 worksheets, having different data. And I want to compare this file with the other file, having 10 worksheets of different data; but the format of the worksheets in these both files are the same(the arrangement of rows and columns in the worksheets in both files are the same).
I have tried to compare two worksheets, in which I succeeded so far, but now I want to compare complete files of these worksheets.
Waiting for your help in near future and thank you for the same in advance.
Vishal
I am searching for a VBA code with which I can compare two (or more, may be) xls files, and generate a resulting file which shows where the data or strings are not equal.
My xls files contain several data in terms of worksheets inside them, so for example, one xls file contains 10 worksheets, having different data. And I want to compare this file with the other file, having 10 worksheets of different data; but the format of the worksheets in these both files are the same(the arrangement of rows and columns in the worksheets in both files are the same).
I have tried to compare two worksheets, in which I succeeded so far, but now I want to compare complete files of these worksheets.
Waiting for your help in near future and thank you for the same in advance.
Vishal