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?
28952 Table Maintenance generation & validation using events Create table lets say ZXXXX hold Object Locations. Field key data element Type Length Dec text MANDT x MANDT Clnt 3 0 Client ZCTRY x LAND1 Char 3 Country Key ZOLOC x ZOLOC Char 15 Object Location ZOLOC20 ZOLOC20 Char 20 Object Location short text ZOLOC40 ZOLOC40 Char 40 Object Location long text ZAWSYS LOGSYSTEM Char 10 Logical System ZSTREET AD_STREET Char 60 Street ZSTREET2 AD_STRSPP1 Char 40 Street 2 ZPOSTAL_CODE AD_PSTCD1 Char 10 City postal code ZCITY AD_CITY1 Char 40 City ZCOUNTRY ZLAND Char 3 Address Country ZOBJ_SIGN ZOBJ_SIGN Char 10 Object Sign ZREF1 ZREF1 Char 10 Reference 1 ZREF2 ZREF2 Char 10 Reference 2 ZREF3 ZREF3 Char 10 Reference 3 ZREF4 ZREF4 Char 10 Reference 4 ZNOTE1 ZNOTE1 Char 20 Note 1 ZNOTE2 ZNOTE2 Char 20 Note 2 ZCREAETDATE CREATEDATE Dats 8 Creation/Change Date ZCREATETIME CREATIETIME Tims 6 Creation/Change Time Create a table maintenance generator for ZXXXX. Create two events in Table Maintenance Generator: - To update the filed value SAP in ZAWSYS and creation date and time - To update change date and time after saving the entry Event ‘21’ – At Create: ZXXXX-ZAWSYS = SAP. ZXXXX-ZCREATEDATE = sy-datum. ZXXXX-ZCREATETIME = sy-uzeit. Event ‘01’- After Save ZXXXX-mandt = extract+0(3). ZXXXX-zctry = extract+3(3). ZXXXX-zoloc = extract+6(15). ZXXXX-zoloc20 = extract+21(20). ZXXXX-zoloc40 = extract+41(40). ZXXXX-zawsys = log_sys. ZXXXX-zstreet = extract+91(60). ZXXXX-zstreet2 = extract+151(40). ZXXXX-zpostal_code = extract+191(10). ZXXXX-zcity = extract+201(40). ZXXXX-zcountry = extract+241(3). ZXXXX-zobj_sign = extract+244(10). ZXXXX-zref1 = extract+254(10). ZXXXX-zref2 = extract+264(10). ZXXXX-zref3 = extract+274(10). ZXXXX-zref4 = extract+284(10). ZXXXX-znote1 = extract+294(20). ZXXXX-znote2 = extract+314(20). ZXXXX-zcreatedate = sy-datum. ZXXXX-zcreatetime = sy-uzeit. modify ZXXXX.
1 6869What as Action? Why we use? What are the conditions we have? What type of actions you have used, for which scenario explain?
1 6493Post New Wipro Interview Questions
what are the storage devices you have worked on?
What do you understand by crawl stats in seo?
Any scope of improvement that you see in yourself and how are you going about it?
What is select clause and where clause in linq?
Define immutable object?
What are anonymous methods and lambda expression?
what is valuation code and valuation modifier in sap fico
What is a designer? : sap bobi
What are basic keywords?
Can you please explain the difference between thread and process?
Is arraylist type safe in c#?
Differentiate list and tuple with an example?
What javascript libraries and frameworks are available?
Explain what are wrapper classes?
What are the classes, Tables, Forms and Methods used to post the purchase orders?