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
what is run-time data?
which type of testing process are you following in ur company? how to recognize a qtp page?
What are the automation metrice in your project?
what is description object?
hi guys, pls tell me for testing institution training hub, hitech city is best or not?
How many lines of code in each script of QTP?
How many add-ins comes by default with qtp?
how can i call function (which has link with excell sheet at a remote location) within another function
How can I open a EXCEL file from QTP Resultviewer with reporter.ReportEvent function call. Example: Test files for details click "here". And clicking "Here" in the resultviewer will open a local EXCEL FILE.
An object is non standard object, i mapped it to standard object, eventhogh on mapping to standard object i cannot use the methods available on the standard object with the mapped object. How i can use those standard object methods with these mapped object. (((Note : dont tell that we can use virtual object as virtual object is to map nonstandard obj to standard obj)))
What are the types of environment variables in qtp?
i need code for how to click on particular mail in utlook mail box .its urjent Thank You Balaji
How many tabs are available to view your test in a test pane and what are they?
Explain about the test fusion report of quicktest professional?
Explain hybrid framework with advantages and disadvantages?