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 / manjunathareddy
Set oExcel=CreateObject("Excel.Application")
Set oBook=oExcel.Workbooks.Open(Excelpath)
Set oSheet=oBook.Worksheets(Excelsheetnumber)
oRow=oSheet.Usedrange.Rows.Count
For i=2 to oRow
Un=oSheet.Cells(i,1).Value
Pwd=oSheet.Cells(i,2).Value
Msgbox Un
Msgbox Pwd
Next
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Mention what is the difference between vbscript and vba?
There are 5 web pages.write a script to click the button on 4th web page.
Which object is used to work with the excel sheets in the vbscript language and what statement is used to create this object?
How will you compare two strings in vbscript?
What is the difference between function and procedure?
wht must be the interview question on corinthian information technology solutions incorporated.
Difference between dim,public and private variables in vb script?
How can the spaces from the string be removed?
what is the features of visual basic?
What aspects of vbscript make it safe so that a web page using vbscript cannot destroy or corrupt information on a user's computer?
I need to get some data from data base and store this
(retrieved) data in a excel sheet using VB script in QTP9.0
I have created connection for data base
I have created as excels sheet by using
Set XL=CreateObject("Excel.Application")
XLworksheet.cells(1,1).value= rs.fields.item("<
Which operator is used for fetching the modulus of the 2 numbers in the vbscript language?
Explain about constants in vb script?
Is VB Script Case sensitive or Case insensitive?
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