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
How to access array data?
Explain about adodb.stream class?
What is variant in vb script?
Is VB Script Case sensitive or Case insensitive?
Which operator is used to concatenate the 2 values in the vbscript language?
Explain the constants in vbscript?
hi what is called GUI in QTP 8.2 and how can we test the apllication using GUI?
Give me sm ideas to write Vbscripts abt protocol testing abilash700@gmail.com.
What is the purpose of regexp object in vbscript?
How to open browser in vb script?
how to increasing the numbers in a given text box please write a vb script
What is the extension of the vbscript file?
Mention when to use function procedures and what are its characteristics?
Please let me Know regarding any material regarding VB Scripting which should be easily understandable for Beginners.
How should i Create Email invite with server-side Coding?