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?
2792Post New Wipro VB Script Code Interview Questions
What are parameterized reports?
plz send me hsbs finance questions asked in the interview ans appitude also
What is the purpose of the partition table?
-----------With out using DrillThrough how to do Reports?
When would you prefer to have a minimum number of indexes?
What do you mean by ternary operator in java?
What is finance lease? What are bonus Shares? entry for it. What is Depreciation? What is the Journal Entry? What is DPS? What is minority Interest? where it is shown?
List out the names of programming languages, browsers and operating systems that are supported by selenium.
Explain the otto cycle in brief.
what is the default security setting in .net?
What does nvme stand for?
What is nsmanagedobject?
How do you identify between actual alarm and false alarm in a Temperature Transmitter in SCADA based Control System
how can you perform exception handling without using component like tjava,tjavarow?
What are the basic features of ms access?