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?
2892Post New Wipro VB Script Code Interview Questions
How are csrf tokens generated?
Is spark built on top of hadoop?
How you can use recovery scenario with selenium?
i have done mba bt didnt wrked after cmplteting the course....now if i go for a intervu....wht cud i reply to the employer abt d 2 yr gap
How to set authorization headers in get/post/put requests in angular?
How do I start mongodb in ubuntu?
Why join is faster than subquery?
Table events aNd table maintains generation
What is the use of mid function in excel?
What do you know about seam?
What is args c#?
what is pl to pl in fire alarm system?
which property among the following generally decreases from top to bottom in a group 1a? 1. Electropositive, density, basic nature, classical reactivity
Is there any program/report which gives payment usage/document set off details against a particular document ?
Why 8051 is called 8 bit microcontroller?