I want to Compare 2 excel Sheet s

How to upload a values from notepad or (Mainframe fields ) into Excel Sheet ?

How to save it ?

After getting the values i want to compare 2 excel sheets ?

Pls help me anyone for the above Query .

Thanks
Nani

re: I want to Compare 2 excel Sheet s

kindly post the code that you are working on.

re: I want to Compare 2 excel Sheet s

First find out the filled number of columns and rows in the sheet with which you want to campare the other sheet. Say filled col are fCols & rows fRows. Now with the help of loops like:

For i = 1 TO fCols
For j = 1 TO fRows
.....here you compare each cell of sheet1 with sheet2 (Sheet1 is master & sheet2 is to be compared).
like
If Sheet1.Cells(i,j).Value = Sheet2.Cells(i,j).Value Then
....put your code here which u want to get / do.
Next
Next

I think this way u can compare each cell.