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?
2799Post New Wipro VB Script Code Interview Questions
how calculate intrest on advance tax ? and penalty on vat?
Search for: can excel be a database?
What are some examples of schemas?
what will be salery for a per who complet bba in a university
Biologists usually refer to the head of a tapeworm by what name?
Which newspaper do you read and why?
What is a class in java?
Does windows 10 come with a word processing program?
What are the additional covenants in term loan agreement to protect lenders?
Enlist the CallBack methods of Entity Bean.
What is the difference between changewatcher.watch, and bindingutils.bindproperty?
What is a system 32 error?
what are arboreal animals?
What is the copy idms subschema-binds in idms?
How do I declare a variable in mysql?