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?
1 2932Post New Wipro VB Script Code Interview Questions
Bonjour, svp je veut voir comment envoyer un mail en java et comment changer le droit d'accé d'un fichier en java: de lecture en lecture/écriture et merci d'avance ;)
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
can any body sand me previous exampapers of jr. engineer (mechanical)
Tell me one thing about yourself you wouldn't want me to know.
any one can send me instrumentation previous interview papers? I prepare for MNC Company Interviews? my mail id- Rakesh.Golla@dodsaldxb.ae , and another mail rakesh.gvk@gmail.com
TELL ME YOU HAVE SEEN CROWDED MARKET?
pls send me HPCL model question paper for the post of officer trainee for mechanical engg. tnk u....
what kind of frame work you used in your last project?
WHICH QUESTIONS ASKED IN EPFO IN 2009.
what is the age limit for groups1 examination
How c functions prevents rework and therefore saves the programers time as wel as length of the code ?
Who is the chairman of LIC?
What are your expectations from life?
How do you check if a list is empty in python?
HOW MUCH YOU WHERE GETTING THERE|?