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
Why is error handling required?
what is used of Property........End Property loop ? how to write the script for it?
How will you get a random number between 0 and 1 in vbscript?
What's the difference between vbscript and vb.net?
We have 1 web page with names column. I am giving the Service Providers1,2,3.... @ that time dynamically some no of names are displaying in the webpage and The Pop up windows are opening(No.of Pop Up windows=No.of Names). The names may be diffar for each and every Service Provders (Dynamically) How can we handle the Dynamic values?
Explain the .wsf files?
How to Convert Hex color code to color name in VB Script?
how to increasing the numbers in a given text box please write a vb script
How to Import data from a file (file is on the desktop) to the data table
Write program for identifyig duplicates in flight Departing from and Arriving in mercury tours(web application).
after medical test,when will be the police verification
How to assign a numeric value to a variable?
Is vbscript language a case-sensitive language and what does it mean?
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?
What are subprocedures in vbscript?