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?
2800Post New Wipro VB Script Code Interview Questions
How HDFS client divide the file into the block while storing inside HDFS?
Give examples for reference types?
what is the difference between websphere and weblogic?
Can you explain usability testing?
What is the method of migrating the universe across domains and/or repositories? : bo designer
What are new features postgre 9.1?
Can we delete data from a view?
What is the difference between $_files['userfile']['name'] and $_files['userfile']['tmp_name']?
Volga is a large manufacturing company in the private sector. In 2007 the company had a gross sale of Rs.980.2 crore. The other financial data for the company are given below: Items Rs. In crore Net worth 152.31 Borrowing 165.47 EBIT 43.17 Interest 34.39 Fixed cost (excluding interest) 118.23 Calculate: a. Debt equity ratio b. Operating leverage c. Financial leverage d. Combined leverage. Interpret your results and comment on the Volga’s debt policy
Differentiate between width() vs css(‘width’) in jquery
Which version you are using js?
What is dbdgen process?
What suites of the 2007 microsoft office system work with office sharepoint server 2007?
How many tabs can I create in excel?
What is truncate table?