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.



Here in my automation tool, i am retreiving some values and i need to store this values in the exc..

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

Post New Answer

More VB Script Interview Questions

Why is it recommended to close the database connection every time after the work is completed?

0 Answers  


Which object provide information about a single runtime error in a vbscript?

0 Answers  


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

4 Answers   TCS,


How will you get the octal value of the given number in vbscript?

0 Answers  


Which function is used in the vbscript language to convert the specified expression into a date type value?

0 Answers  






Out of the different type of operators, which are evaluated first and last in the vbscript language?

0 Answers  


How can I get the value of an object property or variable in another frame?

1 Answers   Citi Bank,


Mention what is byref and byval parameters in vbscript?

0 Answers  


What is the difference between function and procedure?

0 Answers  


What are the differences between Visual Basic, VBA and VBScript? When would it be appropriate to use one as opposed to another?

1 Answers   Infosys,


What is purpose of scripting.filesystemobject class in vbscript?

0 Answers  


when we use filter funtiom invb script(QTP)

0 Answers   TCS,


Categories