ExcelCom help

[Paulie]

What is the '_ExcelCom' func that i would use to do this

I have 2 name-number lists, with phone numbers one has more names than the other, and i need to add names that arent on that one from it to the other, seeing as there is over 650 lines in these sheets, i REALLY wany to find the differences automaticallty

All i need is the functions, and how to use the Syntaxs,

any ideas?

[randallc]

Hi,

Use

$XLArray1=_XLArrayRead($FilePath1,1,"usedrange")

for each sheet,

then compare the arrays, then write back the array;

_XLLastRow(ByRef $s_FilePath,$s_i_Sheet=1,$s_i_Visible=0 ,$i_Suppress=0)

_XLArrayWrite($XLArray2, $FilePath2,1,1,$LastRow,0 ,0,0)

Best,Randall