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
filter the array values without using filter function?
Give examples where vb script can directly run on users system with windows as os?
Which date function is used in the vbscript language to find the difference between the 2 dates?
If we take 2 strings as “good” and “bad” then what will ‘+’ and ‘&’ operators return?
In QTP how to insert a data base check point for web based application and simultaneous link to code in expert veiw. hw to retrieve a data(single coulumn from server) that matches with inserted value manually or exported from excel sheet.
Develop a parameterized action that accomplishes the following a. Launch a browser of users choice ( example : IE, chrome etc) b. Open up a search engine (Google, Bing etc) c. Perform a search d. Click a particular link depending on the user’s choice ( 1st , 2nd or third link)
How to open browser in vb script?
I want to count the total no of links present in yahoo home page. The script like Set fileSysObject=createobject("Scripting.FileSystemObject") Set linksFileName=fileSysObject.opentextfile("D:\samplelinkfile.txt",2,true) Set linkDescObj=description.Create linkDescObj("micclass").value="Link" Set noOfLinks=browser("yahoo").Page("Yahoo!India").ChildObjects(linkDescObj) For i=0 to noOfLinks.count-1 linkName=noOfLinks(i).getROProperty("name") linksFileName.writeline(linkName) Next linksFileName.close Set fileSysObject=nothing But while running the script it is fail (the object not present in the object repository).How to overcome please tell me the detail steps...for QTP9.30
How are values assigned to string type and numeric type variables?
What are keywords in the vbscript language?
Write a VB Script to count blank Lines in a notepad
Out of the different type of operators, which are evaluated first and last in the vbscript language?