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
Does outlook use imap?
How capacitor bank can prove superior to synchronous condensers with respect to power factor correction?
Explain the auto storage classes in c++.
Can you implement Chatbot using Tensorflow ? If yes/ How you can do that ?
How many relationships are present in Salesforce?
sql database suspect We have a sql database that is showing as suspect. How can we recover?
Enlist some of the key challenges that are faced while performing software testing.
What is the difference between supervised learning an unsupervised learning?
why only exciting current is shown not primary current in transformer???
Explain the role of NLP in human-AI interaction.
How do I open outlook without an account?
Why doping is done in semiconductors?
Which columns go to the fact table and which columns go the dimension table?
Explain why a voltmeter should be of very high resistance?
List out standard datatypes in python