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
- 10100 Views
- HP, I also Faced
- E-Mail Answers
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
What is purpose of scripting.filesystemobject class in vbscript?
I have an excel sheet with multiple ID's in a column. Now i need fetch those ID's in an application and check whether if it already exist in the DB. If not then i have to go with the process of inserting them in the DB. If it exists then i need to skip that ID and move to the next ID and check the same and proceed. How can i do that with for loop and if condition?
What is the difference between javascript and vbscript?
Mention the rules for using option explicit statement?
How to Import data from a file (file is on the desktop) to the data table
In what way program "hello world" you can write in vbscript?
Anyone have qtp11.0 crack?
What are class variables?
How to open excel in vb script?
Hi, Can anyone please send me vb script examples to practice vb and also material to learn vb scripting in QTP? my email id : hareen_11@yahoo.com
write any ttest cases using check points and parameterization
How will you get a string with the specified character the specified number of times in vbscript?
What is the main difference between function and sub-procedure?
How will you convert a string to upper case string using vbscript?
How to open browser in vb script?
