How to store the iterations value in some variable/ in excel? Dim objExcel, ObjFolder, objPath, objWorkbook, objSheet, ObjFSo, ObjFolderName, strExcelPath Const xlExcel7 = 39 ObjFolderName = "Testing" & Hour(time()) & Minute(time()) &Second(time()) objPath = "D:\" strExcelPath = objPath & ObjFolderName & "\testing.xls" Set ObjFSo = CreateObject("Scripting.FileSystemObject") Set objFolder = objFSO.CreateFolder(objPath & ObjFolderName) On Error Resume Next Set objExcel = CreateObject("Excel.Application") If (Err.Number <> 0) Then On Error GoTo 0 Wscript.Echo "Excel application not found." Wscript.Quit End If On Error GoTo 0 Set objWorkbook = objExcel.Workbooks.Add() Set objSheet = objExcel.ActiveWorkbook.Worksheets(1) Dim arr1, arr2, arr3 Set outputLines = CreateObject ("System.Collections.ArrayList") arr1 = 123arr2 = 99 arr3 = 10 outputLines.Add arr1 outputLines.Add arr2 outputLines.Add arr3 outputLines.Sort() For Each outputLine in outputLines WScript.Echo outputLine ' how to store this value in excel/ variable? Next objExcel.ActiveWorkbook.SaveAs strExcelPath, xlExcel7 objExcel.ActiveWorkbook.Close objExcel.Application.Quit This above code is working fine but the qs is is there any way to store the sort data in variables / in the excel and how?
2851Post New Wipro VB Script Code Interview Questions
Explain the difference between nematocyst and spicules?
how do you write a function that takes a variable number of arguments? What is the prototype of printf () function?
Expression studio orvisual studio, which one better to use for developing silverlight application?
State the different editions of sap hana?
Which one of the command is ‘highly’ not recommended to use if the application is local and offers full support of objects for automation?
What is the purpose of folders object of scripting.filesystemobject class in vbscript?
How do you flush privileges?
Name few file formats to which a photoshop project can exported to.
How can I copy a standard table to make my own z_table.?
is there any method to interact with LnT ER300P trivector meters and fetch data from that online from remote? the distance between the meter and the pc will be about 4 km.plz reply.thanks
Explain bootstrap program in operating system.
Does sql backup shrink transaction log?
How does pig work?
Explain percentage reserved.
What is executor memory?