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 / bfakruddin
option explicit
dim xl,rc,UserID,pwd
set xl=createobject("excel.application")
xl.visible=true
xl.workbooks.open "path of your excel sheet"
xl.sheets("Sheetid").select
rc=xl.sheets("Sheetid").usedrange.rows.count
for i=0 to rc
UserID=xl.cells(i,1) 'here 1 is column no.userid contai
pwd=xl.cells(i,2) 'here 2 is column no. password contain
object.set UserID
object.set pwd
Next
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the .wsf files?
What are the disadvantages of vbscript?
What are events in the vbscript language?
A folder is there inside no of textfiles are avilable. How do count the textfiles. Normally folder means we are using subfolder methods but textfiles is not working for subfolder methods and how do get file name also.
i am having some basic knowledge in c and VB 6.0. i qtp i want to know how to write the codings. by recording it is generating lot of codings. for example i want to test the text box. senerio is text box should not accept alphabets if it accept alphabets we should return fail status if it get number we should return pass status. how to write coding in vb script please help me
When does ‘on click of button’ event gets triggered in the vbscript language?
who will create the object?
How to find the font in qtp. Scenario:After entering the username and passwd you will be navigate into the "welcome:Username" page.Now I want to extarct font for this message.
Explain the support of asp for vb script functionality?
how does vb script help in web page designing? explain with example.
Does VB/Win make standalone .EXE files?
How will you convert a string to lower case string using vbscript?
how to comvert 120 into one hunderd twenty rupees only and vice varsa
How to open excel in vb script?
Mention the rules for using option explicit statement?