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?1975
Name the function which helps to change the files permission
What is foreign key table in siebel?
Destructors CANNOT be implemented in which one of the following?
Explain about the hierarchical model of the database?
What is microsoft visual c++ 2015 redistributable package x64?
What is the name of the system variable that holds the contents of the selected line in interactive reporting?
How do I change the text direction in word 2016?
How do you integrate spark and hive?
which is the best bidding option for an advertiser who wants to drive more clicks from mobile devices?
What database system does Joomla supports?
What is iis and how do you use it?
How do I write my own dtd?
How do I stop apps from running in the background?
Why string objects are immutable in java?
Which are the ways of achieving concurrency in ios?