how to compare two excell sheets by using vbscript??
Answers were Sorted based on User's Feedback
Answer / maruthi ram
Set objExcel = CreateObject("Excel.application")
objExcel.Visible = True
Set objWorkbook1 = objExcel.workbooks.open("D:\maruthi1.xls")
Set objWorkbook2 = objExcel.workbooks.open("D:\maruthi2.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 ? | 6 Yes | 0 No |
Answer / 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 |
Describe how Smart Identification is used
1>How to get the browser name by writing the VBScript. 2>How did you used the GetROProperty and GetTOproperty .give real time scenario. 2>Give and real time ex for the bug having "High Severity and low priority"on banking doamin web based application.
On what document base Descriptive programming is written if build is not yet ready ?
how to create the varibles and how these are connect to qtp? plz tell me
What is load testing?
waht is the difference between QTP 8.2 and 9.0 version
15 Answers AppLabs, CTS, Polaris,
what is the difference between development and testing
i ve an excel in a QC folder. Thru my QTP script i want to open that excel in runtime. I am running this script from QC itself
Where u will use output checkpoint in QTP?
can i login a page by giving username and password and click on ok button through database parameterization.and if its yes then please write the code of that
If there are 100 checkboes in a page then how can we select 10th & 11th & 14th chexkboxes at once through descriptive programing in QTP using vb script. Please send the answers...
On what basis we select test cases to automate?