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

Answers were Sorted based on User's Feedback



Hi , I am new to VBscripting, My requirment is to write a vbscript to read a row (which has coloum..

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

Hi , I am new to VBscripting, My requirment is to write a vbscript to read a row (which has coloum..

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

Post New Answer

More QTP Interview Questions

WHICH PROCESS U FOLLOW IN COMPANY

1 Answers   IGT,


hi,i have a pblm in qtp,im testing an webappl in which different types of error pop up messages are displayed which qtp is not differentiating or it is not recognising. how do i make it recognise different popup errorm messages while writing script?

4 Answers  


How to Get the Run-time value of an object under that web app under Test to the local data table sheet of that Action?

2 Answers  


PLEASE TELL ME WHEN DO YOU USE THE OBJECT SPY AT RUN TIME

4 Answers   Ordain Solutions,


how to select particular value from the combobox in the current page which is entred in the previous page editbox after parameterization?

5 Answers   Ordain Solutions,


What is the ur roles and responsibilities as automation testing engineer?

2 Answers   Atos Origin,


what is the hierarchy to use properties in descriptive programming

0 Answers  


Plz explain about object propeties in object identification? means.. explain about 1. mandatory properties.2. assestive properties 3. ordinal properties.

3 Answers   TCS,


In the website, the protocol has been changed http: to https what you will do? Tell me your approach?

0 Answers  


What are the factors on which script execution time is dependent?

0 Answers  


How to break the object spy ?

0 Answers  


How can we get a textcheckpoint in QTP9.1?

2 Answers   EmTechPro,


Categories