Comparison of one Excel sheet selected columns with other excel sheet sele
In my project I need to compare one excel sheet's particular columns with another excel sheet's particular columns along with the values.Here we know that which columns has to be compared.
I am trying to do the same in vbscript.if anybody can help me then please.
Re: Comparison of one Excel sheet selected columns with other excel sheet sele
If you wish to compare only the values of some particular columns, I would recommend that you create a script which accesses these Excel sheets via Excel's OLE model and compares the values. You can learn how to work with Excel sheets by looking at the sample script located in this folder: <TestComplete 3>\Samples\Scripts\MSOffice\ExcelProject\VBScript\ .