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 / siri
set ex= CreateObject("Excel.Application")
set wrkbk= ex.workbooks.open(excelbookpath)
set objDriverSheet=wrkbk.worhsheets("Sheetname")
dim lgin,pwd,row
for i=0 to 5
row=i
lgin=objDriverSheet.Cells(row,"A")
pwd=objDriverSheet.Cells(row,"B")
msgbox lgin
msgbox pwd
next
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Can any one provide code for Mid(string,start[,length]). I have been asked to write code for Mid(). i.e We need to define our own function say MyMid() which should behave same like built-in Mid function
Explain the extension .hta?
what is the features of visual basic?
Mention what is the use of option explicit in vbscript?
How will you convert a string to lower case string using vbscript?
Mention how to assign a date value to a variable?
Difference between dim,public and private variables in vb script?
What is the difference between vbscript and vba?
What are the data types supported by vbscript?
Explain about tristate constants in vbscript?
In what way program "hello world" you can write in vbscript?
when we use filter funtiom invb script(QTP)
Explain the string concatenation function in vbscript?
Write a code to print numbers from 5 to 0?
Explain about the asc function?