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
What is vbscript language used for and which earlier language is it modeled upon?
If a calulator having 3 buttons (of any number)in 3 of them one is not working properly due to which answer is wrong always. write a script to find out which button is not working properly ?
Explain about operator precedence in vb script?
Hello Friends , I am the new joinner of this website. I am working with Sapient ,Gurgoan I would like to ask few qurries regarding the QTP Tool of (Testing) Currently working on QTP Tool . I would like to no learn VB Script can u name some Books which i get in market. And a small issue in QTP I had 2 users right i have to login and send the document from this user to second user right. when i am send this doc some contendId number generates right. now i am loging into second user and i have to search for that contentId right i found it now i dont want to accept the document so i had an opption of check out ok i have to click on check out my QTP Code is like this Browser(" ").Page(" ").WebTable(" ").ChildItem (3,5,"Image",0).click Browser(" ").Page(" ").Link("ChecK Out").Click i new this code is perfectly right but when i am run the script i have to click on that particular contentId and click on check out but now the Problem is started the error is the document has been already checked out remeber every time my content id changes means it is the new contentId which is not been used atleast once Please help me out in this issue i am in big trouble
Mention what is the technology used by vb script?
How to replace junk code recorded by QTP with a mall function.
Which keyword is used to declare a variable in the vbscript language?
Explain what is loose binding? Why is it not a good practice to use it?
Write a code to print numbers from 5 to 0?
Which command is used for writing text on a page?
How will you get the octal value of the given number in vbscript?
How to use QTP Object in .vbs(vbscript file) file Ex: Browser().., wait(), exist() and etc...
Explain the support of asp for vb script functionality?
How to Import data from a file (file is on the desktop) to the data table
What is variant in vb script?