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

1.I want to establish connection with excel and also want to fetch the data using SQL queries. 2.the code should be written in such a way that in future if I want to migrate from excel to MS excess database , then there should be minimal changes.

0 Answers  


How will you reverse a string in vbscript?

0 Answers  


I have string like hp company.print tis like company hp.write a program in vbscripting

1 Answers   HP,


Mention if qtp generates vbscript code as we record actions, can't it possible to directly write using vbscript code when qtp does the same thing too?

0 Answers  


write a vbscrpit to swap values

2 Answers   Adani,






how to write code: to check whether the window of an Application Under Test exist or not . plz give with example

2 Answers  


write any ttest cases using check points and parameterization

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,


how to comvert 120 into one hunderd twenty rupees only and vice varsa

0 Answers  


Explain the asc function?

0 Answers  


I have a webtable and many objects are embedded in side.(like buttons,checkboxes etc). How to know how many such objects are there? what is the class of that objects?

1 Answers   HP, TCS,


When inserting strings into a SQL table in ASP what is the risk and how can you prevent it?

1 Answers  


Categories