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
Which function is used to perform string comparison?
what is the difference between modular and data and keyword driven framework
when we use filter funtiom invb script(QTP)
What is the main difference between function and sub-procedure?
If a calulator having 3 buttons (of any number)in 3 of them one is not working properly due to which answer is wrong always. write a script to find out which button is not working properly ?
Explain what is loose binding? Why is it not a good practice to use it?
How will you check that a variable is an array in vbscript?
What is the purpose of folders object of scripting.filesystemobject class in vbscript?
how to write a vb script in QTP for yahoo registration form, i want to check the performance also like performance test, stress, load test like that.
why variable name should not exceed 255 characters?
What is the difference between javascript and vbscript?
what is the object hyrarchy in QTP for a web based application
can anyone tell me the procedure of interview held in applabs
Which in-built functions are used to convert the specified expression in the form of date and string in the vbscript language?
By default in vbscript the arguments passed to functions and subroutines are by reference or by value?