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

Dear All, I am geting below IE error whilie executing the QTP scripts in Batch mode "Internet Explorer has encountered a problem and needs to close. We are sorry for the inconvenience." can any one suggest me how to resolve this issue . Thanks Balaji

1768

---

Hi Friends, I have an issue like the describe below: I'm using QTP and I'm testing on SharePoint. As you knoe, SharePoint has a customize function for user, so that, If I add an object Web Table at the first time, that object was recognized by "index" and "html tag", after that, if someone change the display of web part, the "Index" of my object was changed as well and QTP unable to select that Web Table. Can you guide me how to identify or anyway to keep that Web Table object as unique object? Thanks a lot.

3058

---

Hi this is Vinoth. I need a help on below mentioned question A combobox contains list of items assume as 5 I have to get each items Individually and I have to Export to datatable. Please help me on this. Thanks

2175

---

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

1243

---

What purpose does ‘on error resume next’ serves?

1145

---

What is the use of the ‘open’ method to work with the database in the vbscript language and what connection string is passed in the same and what is its usage?

1066

---

How regexp.execute method works?

1115

---

What aspects of vbscript make it safe so that a web page using vbscript cannot destroy or corrupt information on a user's computer?

1162

---

What are the 2 ways in which a variable can be declared in the vbscript language?

1117

---

Mention the environments where vbscript could be run?

1303

---

Please let me Know regarding any material regarding VB Scripting which should be easily understandable for Beginners.

2085

---

about vb scripting programs this type of all question& answers

2180

---

If a calulator having 3 buttons (of any number)in 3 of them one is not working properly due to which answer is wrong always. write a script to find out which button is not working properly ?

2106

---

If else for do while select in vb script?

1244

---

Mention what is the difference between vbscript and vba?

1119

---