Here in my automation tool, i am retreiving some values and
i need to store this values in the excel. How can i achieve
this?. We are using VBA as scripting language. please let
me know if you require any further inputs.
Answer Posted / suryanarayan mohanty
Set fs = CreateObject("Excel.Application")
If Not (fs.fileexists(FileName)) Then
Set fd = fs.createFile(FileName)
End If
Open FileName For Append As 1
Write #1, xyz, dwe, qws
Close #1
End If
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is vbscript language used for and which earlier language is it modeled upon?
Mention when to use function procedures and what are its characteristics?
What are the naming conventions while declaring a variable in the vbscript language?
if u ve resrevation for train and u get a number supose 1234xxxokie.after sucessul entering all required fields. now u put that number in search and want to chk wether these ar same or not if both ar same then its okie otherwise test fail.what would be the vb script code for it to compare these two values of different page.
what is inner join? what is outer join? what is a constraint? tell me about rdbms? tell me about acid properties?
Explain vbscript in detail?
how to increasing the numbers in a given text box please write a vb script
Explain sga memory structures?
what is the differance between BYVAL,BYREF?
What is the use of the ‘open’ method to work with the database in the vbscript language and what connection string is passed in the same and what is its usage?
I have attended Anovatek Software QTP interview. They will give us computer and one web based application with QTP. We have to automate some records (already updated records or new records) using QTP Data driven testing. But we should use for loop? Can any one know how to do data driven testing using For loop?
Is VB Script Case sensitive or Case insensitive?
Mention characteristics of sub procedures?
What is byref and byval parameters in vbscript?
How to replace junk code recorded by QTP with a mall function.