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


Please Help Members By Posting Answers For Below Questions

how to automatically update the sql server2005 database records when insert in vb6?

1716


What are the different types of loops available in the vbscript language?

753


where can i learn VB scripint ?

1858


What is dictionary object in vbscript? Explain?

888


Explain the support of asp for vb script functionality?

855


Which operator can be used to check if two numbers are equal or not in vbscript?

905


Develop a parameterized action that accomplishes the following a. Launch a browser of users choice ( example : IE, chrome etc) b. Open up a search engine (Google, Bing etc) c. Perform a search d. Click a particular link depending on the user’s choice ( 1st , 2nd or third link)

1641


Hi Friends Rajendra this is bhavani prasad, iam working Hyderabad. i faced one problem with qtp recording mode i.e in my application there is 100 records first we click the first record that record will be jumped to next session and 99 records will there stop the recording and run the same script .Run this script qtp does not identify the records. So plz tell me what is the solution.

1816


What is vbscript?

816


Which constant is used for print and display functions and works as same as pressing enter key?

783


How will you reverse a string in vbscript?

868


What is the purpose of regexp object in vbscript?

794


Mention what are the rules to name variable in vbscript?

785


Mention what is select case statement?

754


Give me sm ideas to write Vbscripts abt protocol testing abilash700@gmail.com.

1859