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 / 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 |
Why is it recommended to close the database connection every time after the work is completed?
Which object provide information about a single runtime error in a vbscript?
what is the code in QTP to take screen shot? Please send me any one to my mail id. my mailid is manu.sanepalli@gmail.com
How will you get the octal value of the given number in vbscript?
Which function is used in the vbscript language to convert the specified expression into a date type value?
Out of the different type of operators, which are evaluated first and last in the vbscript language?
How can I get the value of an object property or variable in another frame?
Mention what is byref and byval parameters in vbscript?
What is the difference between function and procedure?
What are the differences between Visual Basic, VBA and VBScript? When would it be appropriate to use one as opposed to another?
What is purpose of scripting.filesystemobject class in vbscript?
when we use filter funtiom invb script(QTP)