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
- 6381 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 description object?
Where we can use the analog mode and where we can use the low – level mode?
If u r using library files (Instead of Check Points) , How do u do bitmap check ?
What is ObjectParamater?
how we connect 1. qtp9.2 to the quality center9.0? 2. Load runner8.0 to the quality center9.0
How do you open adobe acrobat file in QTP and do some testing on that file ?
What are the different types of recording modes in qtp? Which will be used when?
How many types of recording modes in qtp?
What are the different ways to invoke an application using QTP?
In an interview, what r the general questions asked in QTP? pls give me anwser to this question?
QTP script is not working on other's machine..
How software tester can use constants and variables in scripts?
Does QTP run in any environment?
How to export quicktest professional results to an .xls file?
Tell some commonly used Excel VBA functions?
