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


Please Help Members By Posting Answers For Below Questions

How to access array data?

545


Explain about adodb.stream class?

593


What is variant in vb script?

626


Is VB Script Case sensitive or Case insensitive?

640


Which operator is used to concatenate the 2 values in the vbscript language?

559






Explain the constants in vbscript?

566


hi what is called GUI in QTP 8.2 and how can we test the apllication using GUI?

1788


Give me sm ideas to write Vbscripts abt protocol testing abilash700@gmail.com.

1588


What is the purpose of regexp object in vbscript?

559


How to open browser in vb script?

585


how to increasing the numbers in a given text box please write a vb script

1705


What is the extension of the vbscript file?

553


Mention when to use function procedures and what are its characteristics?

628


Please let me Know regarding any material regarding VB Scripting which should be easily understandable for Beginners.

1540


How should i Create Email invite with server-side Coding?

1604