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
Mention how to create a cookie using vbscript?
how to answer "TELL ME ABOUT UR SELF" as exp.person. whr to start and whr to stop. can anyone tel me
What is Procedure or Subroutine in VB Script?
How can you create a file object to work with the files in the vbscript language?
Explain different types of segment?
How to add actions in driver script to run those actions in QTP?
Can anyone send me a vb script function for verifying the functionality of active links on a web page
How to create a function in vbscript?
Hi, Can anyone please send me vb script examples to practice vb and also material to learn vb scripting in QTP? my email id : hareen_11@yahoo.com
What is vbscript?
What is the purpose of drive object of scripting.filesystemobject class in vbscript?
Which operator is used to concatenate the 2 values in the vbscript language?
Which loop is used in case of arrays in the vbscript language?
Explain about adodb.stream class?
Mention what is vbscript?