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 / 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 |
Hi I am having one folder with set of text files now i want to read and write that text files data into QTP. Any help plsss.
How will you trim the spaces on the left of a string using vbscript?
Which object provide information about a single runtime error in a vbscript?
When are redim statement and preserve keyword used in the vbscript language?
Which in-built functions are used to convert the specified expression in the form of date and string in the vbscript language?
What is the use of the formatdatetime function in the vbscript language?
How can you test font size, type and color using QTP tool?
write a vb script to display 3*3 matrix
How can I write HTML text to the window in VB Script?
What purpose does ‘on error resume next’ serves?
What is the difference between function and procedure?
Plz give the vb script for the following scenerio. In travel booking we have to select from delhi to mumbai from the combobox The prices will be display in another combo box .But i have to select the lowest price for it and submit it