Interested to Buy Any Domain ? << Click Here >> for more details...
Hi , I am new to VBscripting, My requirment is to write a
vbscript to read a row (which has coloumns like
Description, Code, date(DD/MM/YY), hours etc) and export
these feilds to a Website and then click on Submit
Automatically on that web page. This it should do for all
the Rows in that excel file. Any help is much appriciated
Thanks
Shalini
- 2 Answers
- 6244 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / samrat
DataTable.AddSheet "qtpsht"
DataTable.ImportSheet path,"srcsheet","qtpsht"
rowcnt=DataTable.GetSheet("qtpsht").GetRowCount
For i=1 to rowcnt
datatable.Getsheet("qtpsht").Setcurrentrow(i)
'Invoke ur application
'get the test data and store in variables
StrDescription=DataTable.Value("Description",qtpsht")
StrCode=DataTable.Value("Code",qtpsht")
Strdate=DataTable.Value("date",qtpsht")
'apply the above variables into ur application and then
submit
'close ur application
Next
hope this meet ur rqmt..
crct me if iam wrong...
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / pinki
Try this may work.
‘Invoke the your application, open the required page
Set objExcel = CreateObject("Excel.Application") '
Creates the Instance of Excel
objExcel.Workbooks.open “ Give the excel sheet
path" 'Opents the excel sheet from given location
objExcel.Visible = False
'***********Assigning the values to the variables
X = objExcel.ActiveSheet.UsedRange.Rows.count
For j = 1 to X
Desc = objExcel.ActiveSheet.Cells(j,1)
Code = objExcel.ActiveSheet.Cells(j,2)
Date = objExcel.ActiveSheet.Cells(j,2)
Hours = objExcel.ActiveSheet.Cells(j,2)
‘*********** Assign the values to Application variables
Browser().Page().WebEdit().Set Desc
‘
‘
‘
‘ click on sumbit
objExcel.Workbooks.close
| Is This Answer Correct ? | 3 Yes | 0 No |
Suppose if a functionalityis not mensioned in requirement document and but its present in application. will it be consider as a bug and viceversa?
I want to see all the properties of agent name in login window. I will use the script Set a=Window("FR").WinEdit("Agent Name:").Gettoproperties( ) msgbox but my question is how to use the msgbox if i use a it will display only a, so anyone pls let me know how to get the display of all the properties using GetToProperties () or GetRoProperties (). Thanks a lot
Hi could some one explan what is the use of the function Defination generator, And how to use the function defination generator.. Explan with the example..
Hi, My Application in Microsoft Dynamic Navision, is it compitibale with QTP? if yes then let me know...and also let me know is there any other automation tool availabe to automate Microsoft Dynamic Navision. Thanks Sandip. +91-9714177088
do you prepared framework,pls answer this
Can we check environment variable value without existing of environment variable
How many ways to configure the application in QTP,Explain
Hi I have exp in manual testing and planning to move in automation testing qtp(9.2).So can help me how to automate customer relationship management tool using qtp and vb script this tool already developed so how can I test it whatever maintaining by development team like documents,various options just give the whole life cycle thanks in advance
i want information about API testing and i want info like how process can be done in company? i want added info like coding ,debugging, desing in c.v ? what should add in c.v for eg banking domin? pls any answer my question?
what is defination of system testing?
3 Answers CodeArrow, Infosys, Omax,
What is smart identification in QTP?
What is the difference between QTP 8.2 and QTP 9.2
WinRunner 
