Answer Posted /

Is This Answer Correct ?    Yes No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

sir/madam, i would like to know the work for fresh engineering electrical graduates in psu,ies etc.,

1333


Explain types of workbook protection in excel.

274


What happened when voltage will half value of current ...

1100


How to retrieve an InterBase Blob in Delphi using SavetoFile?

1318


What are jsr 250 annotations?

162






What is a device queue?

629


How do I force excel to calculate?

304


What are the distribution channels used by the companies to sell their products?

655


What is your knowledge of and experience with standards-based education?

497


What proactive steps did you have to take to increase the output of your position food and beverage operation manager

2687


What are the key components of angular?

454


What is the size of hello packets in eigrep protocol?

606


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?

2444


What have you learned from early versions of the product or service? - Venture Capitalists

968


Explain the properties of sub-query in sql server?

487