Answer Posted /
Is This Answer Correct ? | Yes | No |
Post New Answer View All Answers
sir/madam, i would like to know the work for fresh engineering electrical graduates in psu,ies etc.,
Explain types of workbook protection in excel.
What happened when voltage will half value of current ...
How to retrieve an InterBase Blob in Delphi using SavetoFile?
What are jsr 250 annotations?
What is a device queue?
How do I force excel to calculate?
What are the distribution channels used by the companies to sell their products?
What is your knowledge of and experience with standards-based education?
What proactive steps did you have to take to increase the output of your position food and beverage operation manager
What are the key components of angular?
What is the size of hello packets in eigrep protocol?
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?
What have you learned from early versions of the product or service? - Venture Capitalists
Explain the properties of sub-query in sql server?