I want to assign values in a table in my software, in first column i will give values, table is of 4x4 i.e 4 row and 4 columns, i m using VBScript in my automation work. it is a simple table for giving values.
Answer Posted / pravinkumar
Set exc=createobject("Excel.application")
set a=exc.Workbooks.Open("C:Documents and SettingspravinkumarmDesktopNew Folderpra.xls")
Set s=exc.Worksheets.Item ("sheet1")
exc.Cells(1,1)="Hello"
Exc.Cells(1,2)="Welcome"
Exc.Cells(2,1)="Hi"
Exc.Cells(2,2)="Jim"
exc.ActiveWorkbook.Save
'a.Save
exc.Quit
Set a=nothing
Set s=nothing
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Define virtual object?
In qtp, explain what is keyword driven automation framework?
What is text/text area checkpoint?
How do you perform Regreession Testing?
Hi, I am working on microsoft infopath forms..It is standalone form..(not dotnet or web.) . I am not able to indentify any objects in it.. I am currently using active accessibility in the macro for the same but its execution is too slow.. Kindly help in case you have better solution.
what is run-time data?
Which scripting language used by quicktest professional (qtp)?
which type of testing process are you following in ur company? how to recognize a qtp page?
How do you know the location Id of an object if you know its index id?
What are the features and benefits of quick test pro (qtp 8.0)?
In the Hybrid framework, data can access the database, excel file, XML etc. Is it true?
What is parameter in qtp?
What are the types of environment variables in qtp?
Explain different checkpoints in qtp.
How to find Operating system information using QTP script?