Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 4 Answers
- 5194 Views
- TCS, Wipro, I also Faced
- E-Mail Answers
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
Explain the concept of how quicktest professional (qtp) identifies object?
Tell some commonly used Excel VBA functions?
Hi All, I need code for how to execute qtp scripts from excell sheet
If we put all properties in mandatory and assistive list of Normal Identification, Do we still need Smart?
i have to login into gmail loginpage i have to pass testcase into userid and password by using functions. the test case of user id is it should take only lowerletters alphabetin between 4 to 6 length.it should not take spectial letters.it should not take numbers.testcase for password is it should take numbers and it should not take alphabets note the following things must happen 1 when i give correct password and userid that password and userid should be seen in QTP result and notepad,xl sheet 2 when i gave in valid password the system willgive message please give valid password that particular messaage should be seen in QTP result,norepa and xl sheet
What is expert view in qtp?
What is the difference between local and shared object repository in qtp?
how do you parameterize search button from the website? the page is a single winobject and i have made a virtual object button of search button but search box can't be converted into a winedit and if we try to convert it into winedit the value we enter in a searchbox appears as numbers in the script so we arent able to parameterize.help!!!
How QTP identify the system time that's changes every seconds?
How do you test DLL files using automation Tool QTP?
In an interview, what r the general questions asked in SQL which is realted to testing ?pls give me anwser to this question?
What are the advantages of parameterization ?
With what extension you can save the list of tests in a file to run in test batch runner?
What is meant by Step generator?what is the use of this? we have 3 steps know there what r all those.? can u all pls give me clear idea of this
If you have two monitors one is of 19inch and the 2nd one is of 24inch,if you want to write same QTP script in both the two monitors is there any changes required in the script?
