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("<<The
data retrieved from data base >>")


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




No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More VB Script Interview Questions

Can any 1 modify the code whr in want to add\rename a excel sheet in qtp?

1 Answers  


Which data type/types are supported by vbscript language and what are their specialties?

0 Answers  


Both Static and dynamic arrays are handled by VB script. Is it true?

0 Answers  


Mention what if you do not specify anything when you call a procedure?

0 Answers  


Hi All, I am facing one problem in QTP. There is link object in my application that exist in the Frame in mozilla firefox. Click event on that object is not working but once the frame is enabled/activated then click event works fine.But the frame does not have the activate property. This problem is coming in firefox only. Regards

0 Answers  






how to comvert 120 into one hunderd twenty rupees only and vice varsa

0 Answers  


A folder is there inside no of textfiles are avilable. How do count the textfiles. Normally folder means we are using subfolder methods but textfiles is not working for subfolder methods and how do get file name also.

0 Answers  


There is a web Table where You will find Two Columns First Column consist of Check box and Second column consist of Test cases ID(Viz T1,T2,T3....Etc); If You select any Test case ID, respective Check boxes to be checked write a VBSCRIPT for this scenario?

1 Answers   eMids,


Write a Program to add 2 numbers without using operators (+,-) and without using third variable. Note: Use VBScript only Hint: You can use other operators like '/' & '*'(Division & Multiplication)

0 Answers   Quest,


How will you generate Reports using Vb Script?it asked in testing(QTP)Interview.Plz Any Body Let me know. Thanks uday Uday_testing@yahoo.co.in

4 Answers   NIIT,


what does create object actually do when you call it in vbscript?

1 Answers   Cap Gemini,


Which respective symbols are used to separate a line and to break the lengthy statement into multiple statements in the vbscript language?

0 Answers  


Categories