how to compare two excell sheets by using vbscript??
Answer Posted / deven
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
Set objWorkbook1= objExcel.Workbooks.Open("E:\Deven1.xls")
Set objWorkbook2= objExcel.Workbooks.Open("E:\Deven2.xls")
Set objWorksheet1= objWorkbook1.Worksheets(1)
Set objWorksheet2= objWorkbook2.Worksheets(1)
For Each cell In objWorksheet1.UsedRange
If cell.Value <> objWorksheet2.Range(cell.Address).Value
Then
msgbox "value is different"
Else
msgbox "value is same"
End If
Next
objWorkbook1.close
objWorkbook2.close
objExcel.quit
set objExcel=nothing
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
UFT 12.02 which ALM version will support
How to upload excel files into Quality Center using QTP Script and how to delete excel files from Quality?
Can launch two instances of qtp on the same machine?
What are the advantages of Object Repository?
Hi, I am using OutputCheckPoint and I am storing the value in the data table. The stored value for column:bedroom:"Bed:4" The another value for column:bathroom:"Bath:2 Full,1 Partial" I need only the no 4 from the first column. I need only the no 2,1 from the second column. I used split array,but it also show array(0) has the value"bed:4" ..... Even though I highlight only 4,It is seleting the full value "bed 4".How can I get only the nos Thank you Uma
Pls can anybody send me the Recent Technical and Interview Questions Which were asked in IBM(QTP)Automation PLZZZZZZZZZ
What is clean sweep?
desribe a situation where u faced a stressful situation and how did u cope with it
what is the difference between data driver & data driven and driver script?
How many tabs are available to view your test in a test pane and what are they?
I am getting the "test object property" Description properties "toolkit class" value By using "gettoproperty" in run time But my problem is how to get Ordinal Identyfier's type and value Type is index, value is 0 How can i keep this values in to required place How can i get these values in runtime I have to insert these "index" and "value" into another area Is there any script for this like "gettoproperties","Getroproperties" If anybody knows,please help me .
What is business process testing(bpt) in qtp?
The hybrid framework can be implemented for any application. Is it true?
In keyward driven framework what will be the step for yahoo login page ,inbox logout,plz explain in detail
Hi frnds, does anybody know if there is anything called "thin point" or something in qtp? thanks in advance.