Interested to Buy Any Domain ? << Click Here >> for more details...
how to compare two excell sheets by using vbscript??
- 2 Answers
- 19145 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Is QTP Supports SWT applications? If yes, can you write a sample script for opening a new package in eclipse.
I have many listboxes in my application. I have to check whether the contents inside the listboxes are in sorted order or not..can anyone please send the code as early as possible
What is business process testing(bpt) in qtp?
On what document base Descriptive programming is written if build is not yet ready ?
What is text/text area checkpoint?
Hi all, I am using windows vista, I am in the process of learning QTP. When ever I try to work with insert mode in flight application , i am getting the error of 'Operation must use an update table query, fractional truncation(null) error. Can anyone help me regarding this?
How you can replace string in qtp?
In application which areas to be automated and what kind of situation will be take? using QTP? Plz give me the clear answer
Is the qtp course will help to create a virtual object?
What is the XML file architecture ?
How qtp recognizes the object?
Explain features of the latest version of qtp/ uft 12.1?
Hi Friends, Would be great if you can provide the Model Question paper, Web site link or any reference s. Thanks & Regards, Byzoor,
i have doubt suppose iam purly working in QTP, when i will work on sql and performence testing? pls any one clarify doubt?
RECENTLY I PLACED IN QTP..HOW TO IMPROVE VB SCRIPTS KNOWLEDGE? IAM STRUGGING TO WRITE THE AUTOMATION SCRIPTS? ANY BODY TELL HOW TO IMPROVE QTP SCRIPT SKILLS?
