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
how to automatically update the sql server2005 database records when insert in vb6?
What are the different types of loops available in the vbscript language?
where can i learn VB scripint ?
What is dictionary object in vbscript? Explain?
Explain the support of asp for vb script functionality?
Which operator can be used to check if two numbers are equal or not in vbscript?
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)
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.
What is vbscript?
Which constant is used for print and display functions and works as same as pressing enter key?
How will you reverse a string in vbscript?
What is the purpose of regexp object in vbscript?
Mention what are the rules to name variable in vbscript?
Mention what is select case statement?
Give me sm ideas to write Vbscripts abt protocol testing abilash700@gmail.com.