Sign in to follow this  
Followers 0
Paulie

ExcelCom help

2 posts in this topic

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?

Share this post


Link to post
Share on other sites



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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0