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 |
* ** *** Please write a code to get output like above diagram? ple explain as it how the code works?
What is the difference between javascript and vbscript?
Write a code to print numbers from 5 to 0?
Which respective symbols are used to separate a line and to break the lengthy statement into multiple statements in the vbscript language?
in qtp we ve datatable look like excel ,if we want to extract data from excel which saved in my documet how can i get that in datatable using vb script
Which data type/types are supported by vbscript language and what are their specialties?
What are the environments supported by vbscript language?
accept an email id & validate it .email id should not exceed 25 characters the mail id should contain 3 characters excluding domain name,@ and .(dot) the last 3 characters of the domain should be net,com or org
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
Why is it recommended to close the database connection every time after the work is completed?
What are class properties?
Which function is used in the vbscript language to convert the specified expression into a date type value?