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?
2789Post New Wipro VB Script Code Interview Questions
How much does it cost to buy windows 10?
What is a scheduling agreement? : fi- accounts payable
What is cargo planning? How do you do that and what are the most Important factors that are kept in mind while planning?
WHAT ARE THE DISTNICT VARIABLES?
Maximum Control Names length?
How uwb (ultra-wideband) is different from firewire?
What is the difference between framework and cms?
What is the purpose of xml?
What is the use of stored procedures?
How to automate a script in mainframes environment? I have the terminal emulator Add in. Describe in detail.
Explain the difference between the required and requiredmessage attributes in the
If DEBT/EQUITY ratio 2:1, is to good or bad for a company? how...??? can u explain it...???
How to cache an observable data in angular 2?
Should controller be singleton?
Which was the most difficult sale you made?