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
Why to use option explicit in vb script?
How to Import data from a file (file is on the desktop) to the data table
How will you get the last occurrence of one string within another string using vbscript?
What are subprocedures in vbscript?
How will you get the octal value of the given number in vbscript?
how to write a vb script in QTP for yahoo registration form, i want to check the performance also like performance test, stress, load test like that.
How will you convert a string to upper case string using vbscript?
Which in-built function related to an array joins substrings into one string in the vbscript language?
Which object is used to work with the excel sheets in the vbscript language and what statement is used to create this object?
How to pass argument by reference to a function in vbscript?
How are arrays declared in the vbscript language?
How will you get the exponent of the given number in vbscript?
How will you reverse a string in vbscript?
Capture the Unique label changes on google home page for I am feeling lucky button and save those label changes to Notepad Note: Using QTP
Explain about the asc function?