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 / 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


Please Help Members By Posting Answers For Below Questions

Why to use option explicit in vb script?

998


How to Import data from a file (file is on the desktop) to the data table

2001


How will you get the last occurrence of one string within another string using vbscript?

1122


What are subprocedures in vbscript?

1056


How will you get the octal value of the given number in vbscript?

911


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.

5154


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

931


Which in-built function related to an array joins substrings into one string in the vbscript language?

906


Which object is used to work with the excel sheets in the vbscript language and what statement is used to create this object?

912


How to pass argument by reference to a function in vbscript?

974


How are arrays declared in the vbscript language?

941


How will you get the exponent of the given number in vbscript?

969


How will you reverse a string in vbscript?

1069


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

2305


Explain about the asc function?

973