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
Which operator is used to concatenate the 2 values in the vbscript language?
What is the use of the formatdatetime function in the vbscript language?
Which constant is used for print and display functions and works as same as pressing enter key?
How do you declare a variable in vbscript?
What is the purpose of folders object of scripting.filesystemobject class in vbscript?
What are the valid scopes of a variable in vbscript?
What is the use of the instr function?
How can you create a file object to work with the files in the vbscript language?
i wrote vbscripit code in notepad i got error i am in learning stage if u ps tell me what wrong in my code my error is "object required descriptive at line one run time error"and my code is "set usernameobj=Descriptive.Create() usernameobj( "name").value="Username" set passwordobj=Descriptive.Create() passwordobj("name").value="password" set signinobj=Descriptive.Create() signinobj("name").value="sigin" browser("gmail").page("gmail").WebEdit("usernameobj").set ("enter username") Browser("gmail").Page("gmail").WebEdit("passwordobj").Set secure.Crypt.Encrypt("enter password") browser("gmail").page("gmail").WebButton("siginobj").click
What is vbscript?
How to get the length of the string by making use of the string function?
What are the disadvantages of vbscript?
What is vbscript language used for and which earlier language is it modeled upon?
Explain the arrays in vb script?
How to open excel in vb script?