Programming Code (840)
Scripts_Markup Code (257)
how to create a Draggable element
snippet to prevent submission of form when certain/any validations got failed
What is the functionality of SendMessage?
how to test pierrot divisor
write a java program to create a Frame with three scrolls, change the back ground color of the frame using functions with values of scrolls.
communication between main window and new windows
How to print sum of the numbers starting from 1 to 100?
how to copy form data between different pages
How to palindrom string in c language?
Write a program that will convert an integer pointer to an integer and vice-versa.
Write a function that takes an unsorted integer array, and returns a three element subset whose sum is zero.
What is XML DOM?
What is the meaning of version in XML?
Code for Easily Using Hash Table?
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?