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


Please Help Members By Posting Answers For Below Questions

What is quick test pro?

592


How can i use virtual objects? If have i created one new virtual object in a virtual object manager by following instructions.

1451


How do you configure QTP AND Test director?

1502


How do you capture tooltip using QTP?

636


How many types of recording modes in the qtp?

598






images are dynamically changes how to compare two images with out using the bitmap

2007


what is the difference between development and testing

2394


How can i initiate the objects to find uniquely in OR

1476


How to make qtp understand the difference amongst the same type of objects .suppose there are 5 check boxes in a page and I have to choose the 2nd one, how to do that through script?

568


is there any addin for remedy user application

1745


In a flight window we have to enter the name and meal request for every passenger.In that window if we give Total passengers=1 then the Psngr1 name field and psngr1 meal request field will reflects.if we give Total passengers=2 then Psngr1 name field and psngr1 meal request field,Psngr2 name field and psngr2 meal request field will reflects and so on.if total psngrs=100 then will we capture all the fields for the psngrs to Automate the app how we can handle this scenerio thru Descriptive programming?

1455


how do u plan test automation?

1447


What is meant by a Check Point in UFT? Also, explain the applicable Check Points.

709


For example you are checking bit map check point before coming to the results. How can you say it is passed? Or failed? Anyways?

618


What is qtp window?

568