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

Explain about tristate constants in vbscript?

0 Answers  


How do display output message without using msgbox function?

5 Answers  


Which is the default Data types in VBScript?

7 Answers   AppLabs,


How can constants be declared in the vbscript language?

0 Answers  


what is diff b/n these 2 programs 1) for i=5 to 1 step 2 msgbox "pass" next 2_) for i=5 to 1 step -2 msgbox "pass" next

5 Answers   Hexaware,


Compare java script and vb script?

0 Answers  


why variable name should not exceed 255 characters?

0 Answers  


Create a file system object to do the following i. Create a folder ii. Create a text file in the folder iii. Update text file with some tex

2 Answers  


which is the bset training centre to learn automation tools?

2 Answers  


Consider there are objects in a webapp which are identified by QTP. Suppose you know only the logical name of a object(absolutely nothing else about it). Which approach will you take to find the "micClass" of the object(You can't use Object Spy, or can't add the object in repository)?

2 Answers   HCL,


1. How to handle object implementation change in DP for Ex: i have login page with username,pasword (editboxes),login,cancel(buttons). Here i written DP code for login page with the help properties. My questions: 1.If properites are changing dynamically i will do (i want code for that) 2.if objects are changed dynamcally i will do (i wnat code for that)

0 Answers   iFlex,


write script to open Gmail.com, and to write script for entering username and password and show whether the result as pass or fail

2 Answers   Thomson Reuters,


Categories