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

How to scroll down a page while recording in qtp. suggest me any method apart from low level recording.

0 Answers  


Which data type/types are supported by vbscript language and what are their specialties?

0 Answers  


Explain sga memory structures?

0 Answers  


Hi I don't have any idea on VBscript. can any one point me to a good web site to learn VBscript. Regards lina

2 Answers  


How to use Text file (Notepad) as ur data source in QTP? Can u please provide some function code for it?

1 Answers  






How can you create a file object to work with the files in the vbscript language?

0 Answers  


What are the 2 ways in which a variable can be declared in the vbscript language?

0 Answers  


How regexp.execute method works?

0 Answers  


1)How to test whether items in a weblist are in alphabetical order or not?

1 Answers   TCS,


hi Set myobj=Description.Create() myobj("type").value="submit" myobj("name").value="google search" myobj("html tag").value="button" browser("title:=google").page("title:=google").webButton (myobj).Click i was running above code in one weak back it was working fine i got result,again i opened after few days ,again i was trying to run the code it shows run time error in last line of my code ,why ?pls answer my question?

0 Answers  


How to write VB script for login module?

0 Answers  


In what way program "hello world" you can write in vbscript?

0 Answers  


Categories