Paulie Posted July 28, 2006 Share Posted July 28, 2006 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? Link to comment Share on other sites More sharing options...
randallc Posted July 28, 2006 Share Posted July 28, 2006 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 ExcelCOM... AccessCom.. Word2... FileListToArrayNew...SearchMiner... Regexps...SQL...Explorer...Array2D.. _GUIListView...array problem...APITailRW Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now