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
Mention what are the rules to name variable in vbscript?
How to check the particular window is exist or not with out using check points
which one is more secure vb script or java script ??????? or both are same ??????
Hello All, In QTP 9.2 for Mozilla Firefox, there is webelement in my application, I tried to click on that using decsriptive programming, but it does not work. and for this i tried this code too: Set obj = CreateObject ("Mercury.DeviceReplay") absx = Browser("").Page("").WebElement(".").GetROProperty ("abs_x") absy = Browser("").Page("").WebElement(".").GetROProperty ("abs_y") obj.MouseMove absx, absy obj.MouseClick absx, absy, 0 But it is not clicked. Can anyone help me out for this problem. Thnx in Advance
what is fire event method in qtp?
I need help to write a function in vbscript to click on a link. That link looks like a tab. There are 6 tabs. When I click on 1 tab it should show as "on". when I spy the class property is on. But for the one which is not clicked the class property is blank. I have objects created in our custom object repository. Please give me some idea.
What are the 2 ways to pass a value to the function?
Write a function for Instr(). We need to write a function that works as same as Instr(). Code or Even pseudo code is good enough for me.?
Mention what is the main difference between function and sub-procedure?
Mention what is vbscript?
who you define variables and functions in VB?
i wrote vbscripit code in notepad i got error i am in learning stage if u ps tell me what wrong in my code my error is "object required descriptive at line one run time error"and my code is "set usernameobj=Descriptive.Create() usernameobj( "name").value="Username" set passwordobj=Descriptive.Create() passwordobj("name").value="password" set signinobj=Descriptive.Create() signinobj("name").value="sigin" browser("gmail").page("gmail").WebEdit("usernameobj").set ("enter username") Browser("gmail").Page("gmail").WebEdit("passwordobj").Set secure.Crypt.Encrypt("enter password") browser("gmail").page("gmail").WebButton("siginobj").click