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?
2440Post New Wipro VB Script Code Interview Questions
What is the difference between slice and dice and cross tab report?
what is meaning of sympathetic tripping with respect to relays and give the values for current carrying capacities for copper and aluminium cables from 16sq mm to 500sq mm
What's Credit card?
Explain Features of Pig?
Can we redefine the field of x(200) to less than 200?
Explain the two ways used to create asset masters? : fi- asset accounting
What are the disadvantages of transgenic animals for neuroscientific studies?
What is cascadetype detach?
What are the steps involved to write rmi based programs?
Is there any provision to include one or more declaration in a selector?
What are the techniques used to sell a product?
What are the other methods working as deployment functionality?
What do you know about facades in laravel? Explain.
What effect does dyhydromonoxide have on green vegetation?
What language is windows command prompt?