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
write a vb script to display calculator using case statement?
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
who will create the object?
What is the use of the instr function?
If we take 2 strings as “good” and “bad” then what will ‘+’ and ‘&’ operators return?
What are the special sub-types in vbscript?
Which conditional statement is the most convenient one to use in the case of multiple conditions in the vbscript language?
Can we create Crystal Report object in QTP?If yes then what it is and what are its various properties?
What is the purpose of regexp object in vbscript?
Write a program to create a Dynamic array of size 5 elements and display all the elements.
When does ‘on click of button’ event gets triggered in the vbscript language?
I want to import the sheet from the Excel to the Datatable using VB Script. I used the Syntax as 'Datatable.ImportSheet "Filename","SourceSheet","Destinat ionSheet" Ex: Datatable.ImportSheet "D:\Data1.xls","Sheet1","Global" Qtp producing run time error,How I can solve the problem