Answer Posted / turtlerock

Datatable.import("c:\one.xls")

1.I want to establish connection with excel and also want to fetch the data using SQL queries. 2.the code should be written in such a way that in future if I want to migrate from excel to MS excess database , then there should be minimal changes.

2015

---

If we take 2 strings as “good” and “bad” then what will ‘+’ and ‘&’ operators return?

991

---

Explain vbscript in detail?

1062

---

Hi Friends Rajendra this is bhavani prasad, iam working Hyderabad. i faced one problem with qtp recording mode i.e in my application there is 100 records first we click the first record that record will be jumped to next session and 99 records will there stop the recording and run the same script .Run this script qtp does not identify the records. So plz tell me what is the solution.

2093

---

write a function to read the items from combobox of Flight reservation & save in excel (QTP)??

2862

---

How to use QTP Object in .vbs(vbscript file) file Ex: Browser().., wait(), exist() and etc...

3453

---

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?

1402

---

Differentiate javascript and vbscript?

1044

---

Mention what is variant in vbscript?

951

---

i am having some basic knowledge in c and VB 6.0. i qtp i want to know how to write the codings. by recording it is generating lot of codings. for example i want to test the text box. senerio is text box should not accept alphabets if it accept alphabets we should return fail status if it get number we should return pass status. how to write coding in vb script please help me

2280

---

What are the disadvantages of vbscript?

1250

---

There are 5 web pages.write a script to click the button on 4th web page.

3417

---

what is resorceallocation

2234

---

I need to get some data from data base and store this (retrieved) data in a excel sheet using VB script in QTP9.0 I have created connection for data base I have created as excels sheet by using Set XL=CreateObject("Excel.Application") XLworksheet.cells(1,1).value= rs.fields.item("<>") I have taken a for loop and changed the cells values (1 as i and another 1 as j) But still I am not able to get Plz kindly tell me know this . It is very urgent

2251

---

How can you create a file object to work with the files in the vbscript language?

956

---