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 |
1.I want to establish connection with excel and also want to fetch the data using SQL queries. 2.the code should be written in such a way that in future if I want to migrate from excel to MS excess database , then there should be minimal changes.
How will you reverse a string in vbscript?
I have string like hp company.print tis like company hp.write a program in vbscripting
Mention if qtp generates vbscript code as we record actions, can't it possible to directly write using vbscript code when qtp does the same thing too?
write a vbscrpit to swap values
how to write code: to check whether the window of an Application Under Test exist or not . plz give with example
write any ttest cases using check points and parameterization
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
how to comvert 120 into one hunderd twenty rupees only and vice varsa
Explain the asc function?
I have a webtable and many objects are embedded in side.(like buttons,checkboxes etc). How to know how many such objects are there? what is the class of that objects?
When inserting strings into a SQL table in ASP what is the risk and how can you prevent it?