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
- 5766 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is meant by a Check Point in UFT? Also, explain the applicable Check Points.
Does any one worked on JIL Emulator , Testing with QTP(automation). Trail Version of QTP is not identifying the child objects of JIL emulator, Can any one help me out ,
What test you perform mostly? Regression or retesting in your testing process?
what is key word driven frame work ? why it is called like that ? what is the diference between keyword driven and data driven frame work ?
What phases are involved in testing an application in qtp?
How can i test an application like Google Earth.In my application data will be fetched from a oracle database based upon which graphs are generated..so these all are dynamic..how can i use qtp here..alongwith that how can i test the map generated by a satellite just like google earth..
Key word driven framework
Suppose I created one object as virtual object? That object is applicable to that test? Or all the tests?
How to perform cross platform testing and cross browser testing using qtp? Can you explain giving some example?
How to give a call to another action from one action?
How to write business scripts using object repository with different scenarios
Explain different types of action in qtp?
what is defenetion of kiran can u tell me plz CVS, SVN
Explain the concept of object repository and how QTP recognizes objects?
How many types of Automation frameworks are there in UFT? Describe them.
