Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6 Answers
- 9789 Views
- HP, I also Faced
- E-Mail Answers
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
Which constant is used for print and display functions and works as same as pressing enter key?
Which in-built function is used to format the number in the vbscript language?
Differentiate javascript and vbscript?
What is purpose of scripting.filesystemobject class in vbscript?
Explain about arrays in vb script?
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.
Both Static and dynamic arrays are handled by VB script. Is it true?
Explain about vb script?
What is the difference between vbscript and vba?
Which operator is used for fetching the modulus of the 2 numbers in the vbscript language?
How can you destroy an object in vbscript?
Explain some uses of vb script?
How can constants be declared in the vbscript language?
1) How can we use VB script in testing the application? 2) What all are the things(Software application to be installed in PC) we need to learn VBscript?
Which command is used for writing text on a page?
