Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

Answer Posted / siri

set ex= CreateObject("Excel.Application")
set wrkbk= ex.workbooks.open(excelbookpath)
set objDriverSheet=wrkbk.worhsheets("Sheetname")

dim lgin,pwd,row
for i=0 to 5
row=i
lgin=objDriverSheet.Cells(row,"A")
pwd=objDriverSheet.Cells(row,"B")
msgbox lgin
msgbox pwd

next

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can any one provide code for Mid(string,start[,length]). I have been asked to write code for Mid(). i.e We need to define our own function say MyMid() which should behave same like built-in Mid function

2366


Explain the extension .hta?

901


what is the features of visual basic?

2038


Mention what is the use of option explicit in vbscript?

917


How will you convert a string to lower case string using vbscript?

963


Mention how to assign a date value to a variable?

1019


Difference between dim,public and private variables in vb script?

900


What is the difference between vbscript and vba?

1055


What are the data types supported by vbscript?

1039


Explain about tristate constants in vbscript?

1027


In what way program "hello world" you can write in vbscript?

1061


when we use filter funtiom invb script(QTP)

2725


Explain the string concatenation function in vbscript?

966


Write a code to print numbers from 5 to 0?

1080


Explain about the asc function?

973