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?
2889Post New Wipro VB Script Code Interview Questions
Show the declaration for a static function pointer.
Which sql server table is used to hold the stored procedure script?
In backbone view, what is the use of setelement ?
What do you know about International Monetary Fund?
Can a subdomain have a different wordpress theme?
Is there any way to skip finally block of exception even if some exception occurs in the exception block?
What is continuous integration (ci)?
Explain cts?
What is cmake in linux?
What is constants in c#?
What types of tools or measuring devices do you use related to math?
Is it possible to schedule a dynamic dashboard in salesforce?
Explain HCatInputFormat?
What is DStream in Apache Spark Streaming?
How do I give myself full permissions in windows 10?