hey please tell me how to retriev data from excel sheet
which puts the login name and password in the application?
plz send me the code..please help me
Answer Posted / manjunathareddy
Set oExcel=CreateObject("Excel.Application")
Set oBook=oExcel.Workbooks.Open(Excelpath)
Set oSheet=oBook.Worksheets(Excelsheetnumber)
oRow=oSheet.Usedrange.Rows.Count
For i=2 to oRow
Un=oSheet.Cells(i,1).Value
Pwd=oSheet.Cells(i,2).Value
Msgbox Un
Msgbox Pwd
Next
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is sql loader? Explain the files used by sql loader to load file?
What is difference between vbscript and vba?
How are arrays declared in the vbscript language?
Explain about vb script?
What is the use of the date function in the vbscript language?
Mention how to assign a date value to a variable?
I have attended Anovatek Software QTP interview. They will give us computer and one web based application with QTP. We have to automate some records (already updated records or new records) using QTP Data driven testing. But we should use for loop? Can any one know how to do data driven testing using For loop?
where can i learn VB scripint ?
How to Enter Values on the Command promt using VB script
write a program to display configuration of a local system with the help of vb script.
How will you check that a variable is an array in vbscript?
What is the difference between vb debugger and the script debugger?
How many types of operators are available in the vbscript language?
What are the 2 ways in which a variable can be declared in the vbscript language?
Which operator can be used to change the value of the operand or change the state of the condition?