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 |
Explain about tristate constants in vbscript?
How do display output message without using msgbox function?
Which is the default Data types in VBScript?
How can constants be declared in the vbscript language?
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
Compare java script and vb script?
why variable name should not exceed 255 characters?
Create a file system object to do the following i. Create a folder ii. Create a text file in the folder iii. Update text file with some tex
which is the bset training centre to learn automation tools?
Consider there are objects in a webapp which are identified by QTP. Suppose you know only the logical name of a object(absolutely nothing else about it). Which approach will you take to find the "micClass" of the object(You can't use Object Spy, or can't add the object in repository)?
1. How to handle object implementation change in DP for Ex: i have login page with username,pasword (editboxes),login,cancel(buttons). Here i written DP code for login page with the help properties. My questions: 1.If properites are changing dynamically i will do (i want code for that) 2.if objects are changed dynamcally i will do (i wnat code for that)
write script to open Gmail.com, and to write script for entering username and password and show whether the result as pass or fail