help!!!

  • Thread starter Thread starter nem
  • Start date Start date
N

nem

if someone could please help...

i was trying to compare 2 files with excel, but retain the colum
propertie names. i read everyone's posts and came up with nothing. an
help would be greatly appreciated.


thank
 
What do you mean by compare. Particularly when you say two Excel files.

What does retain the column properties names mean? Do you mean retrieve
rather than retain? If so, then better definition of compare - compare what
to what?
 
what i mean by compare is...

i would like to compare information that i have on to seperate workboo
files. each one has the same column headings that i would like t
compare the other file with...

ex:

file1 column A compared by file2 column A

then, what i meant by retaining the column headings is to be able to g
back and sort the columns by a different column heading...

ex:

sort by column c

thanks again for the reply. take care
 
With workbooks("file1.xls").Worksheets(1)
set rng1 = .range(.cells(1,1),.cells(rows.count,1).End(xlup))
End With

With workbooks("file2.xls").Worksheets(1)
set rng2 = .range(.cells(1,1),.cells(rows.count,1).End(xlup))
End With

for each cell in rng1
if cell <> rng2(cell.row) then
msgbox "there is a difference
exit sub
end if
Next
 
Back
Top