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?
1863Post New Wipro VB Script Code Interview Questions
What is point-to-point protocol
If a five digit number is input through the keyboard, write a program to print a new number by adding one to each of its digits.For example if the number that is input is 12391 then the output should be displayed as 23402
Write Any Three Kinds of Company According to Ownership?
what are the types of electromagnetic forces developed in practical transformer?
What happen if we apply square wave or traiangular waveform voltage to the transformer primary winding instead of sinusoidal wave?
Why is ignitor used in sodium vapour lamp
how braking & making capacity of circuit breaker is calculated?
The purpose of this exercise is to benchmark file writing and reading speed. This exercise is divided into two parts. a). Write a file character by character such that the total file size becomes approximately >10K. After writing close the file handler, open a new stream and read the file character by character. Record both times. Execute this exercise at least 4 times b). Create a buffer capable of storing 100 characters. Now after generating the characters, first store them in the buffer. Once the buffer is filled up, store all the elements in the file. Repeat the process until the total file size becomes approximately >10K.While reading read a while line, store it in buffer and once buffer gets filled up, display the whole buffer. Repeat the exercise at least 4 times with different size of buffer (50, 100, 150 …). Records the times. c). Do an analysis of the differences in times and submit it in class.
what is the meaning of 4X and 10X value in intraday market?
What types of CMOS memories have you designed? What were their size? Speed?
How to Compare Sockets to Pipes?
Define namespace.
What would you like to do - lead or follow?
What are the possible test cases for hand posture recognition using graph matching algorithm?
after creating lock object if does n't access record by second user what should we do?
- C (153)
- C++ (2)
- STL (10)
- OOPS (37)
- C++ General (30)
- MFC (5)
- COM DCOM (1)
- Win32API (1)
- Delphi (4)
- PHP (13)
- Programming Languages AllOther (19)
- ASP (1)
- CGI Perl (3)
- JavaScript (5)
- VB Script (4)
- JSP (2)
- Shell Script (11)
- Tcl (1)
- AJAX (2)
- Scripts AllOther (2)
- SNMP (6)
- TCP IP (10)
- UDP (2)
- SS7 (1)
- Protocols AllOther (9)
- Networking Administration (27)
- Networking Security (5)
- Networking AllOther (14)
- Visual Basic (14)
- C Sharp (52)
- ASP.NET (63)
- VB.NET (2)
- ADO.NET (9)
- IIS (7)
- Crystal Reports (2)
- Dot Net Framework (4)
- Dot Net WindowsForms (12)
- Dot Net General (24)
- Dot Net AllOther (2)
- Exchange Server (14)
- SharePoint (14)
- WCF (1)
- Microsoft Related AllOther (6)
- Oracle General (46)
- OCI (1)
- Database Management (7)
- Forms Reports (3)
- Oracle AllOther (5)
- SQL Server (59)
- MS Access (2)
- MySQL (5)
- Postgre (1)
- DB Architecture (2)
- DB Administration (4)
- DB Development (1)
- SQL PLSQL (22)
- Databases AllOther (5)
- SDK (2)
- Windows Threads (2)
- Windows General (5)
- Windows AllOther (15)
- Linux Commands (15)
- Linux Threads (1)
- Linux System Calls (8)
- Linux General (4)
- Linux AllOther (4)
- Unix Commands (12)
- Unix Socket Programming (1)
- Unix General (2)
- Unix AllOther (3)
- Solaris Commands (24)
- Solaris System Calls (2)
- Solaris General (72)
- Solaris AllOther (13)
- Vxworks (3)
- RTOS AllOther (1)
- Operating Systems General Concepts (14)
- Data Structures (9)
- Operating Systems AllOther (4)
- WinRunner (15)
- Load Runner (19)
- QTP (144)
- Test Director (2)
- Rational TestSuite (2)
- Silk Test (1)
- Automation Testing AllOther (4)
- Manual Testing (195)
- QA Concepts (8)
- Mobile Testing (2)
- Test Cases (19)
- Test Documents Reporting (2)
- Testing AllOther (11)
- Servers AllOther (4)
- COBOL (31)
- JCL (26)
- CICS (4)
- DB2 (13)
- IMS (2)
- REXX (2)
- Assembler (1)
- MVS (2)
- VSAM (1)
- QSAM (1)
- IBM MainFrame AllOther (3)
- RPG400 (7)
- DB400 (1)
- COOLPLEX (1)
- IBM AS400 AllOther (7)
- Core Java (94)
- Advanced Java (20)
- Swing (4)
- EJB (8)
- Servlets (8)
- Struts (29)
- JDBC (18)
- J2EE (4)
- Weblogic (11)
- Websphere (1)
- Java Networking (3)
- Java J2EE AllOther (2)
- J2ME (4)
- Java Related AllOther (2)
- MQSeries (1)
- Middleware AllOther (4)
- HTML DHTML (1)
- XML XSLT RSS (2)
- Flash Action Scripting (1)
- Web Related AllOther (1)
- Teradata (21)
- Business Objects (40)
- Cognos (32)
- Informatica (92)
- Ab Initio (9)
- Data Stage (43)
- SAS (9)
- ETL (2)
- Data Warehouse General (4)
- HR Questions (52)
- Design Patterns (6)
- OOAD (3)
- Software Design Tools (2)
- Requirements Management (2)
- Project Planning (3)
- Project Management (4)
- Software Design AllOther (2)
- Debugging AllOther (3)
- Clear Case (2)
- Telecom Routers Switches (1)
- Telecom Protocols (2)
- Voice Gateways (1)
- Telecom Security (1)
- WiFi Protocols (1)
- BlueTooth (3)
- Telecom General (1)
- SAP Basis (31)
- SAP ABAP (108)
- SAPScript (4)
- SAP SD (112)
- SAP MM (21)
- SAP QM (1)
- SAP PP (18)
- SAP FI CO (74)
- SAP HR (30)
- SAP CRM (59)
- SAP SRM (1)
- SAP APO (2)
- SAP Business Warehouse (6)
- SAP Business Workflow (3)
- SAP Security (10)
- SAP ALE IDocs (1)
- SAP B1 (5)
- SAP AllOther (2)
- PeopleSoft HRMS (1)
- Oracle Apps Technical (28)
- Oracle Apps Financial (27)
- Oracle Apps Manufacturing (3)
- Oracle Apps HRMS (1)
- Oracle Apps SCM (3)
- ERP CRM AllOther (4)
- 86 Family (14)
- VLSI (8)
- Embedded Systems AllOther (1)
- Client Server General (5)
- Client Server AllOther (1)
- AI General (1)
- Encryption Decryption (1)
- Cryptography General (1)
- WebMethods (2)
- TIBCO (11)
- JCAPS (1)
- 3D Animation (1)
- Visual Effects (1)
- Software Integration & Delivery (1)
- Software Integration & Release (1)
- Image Processing General (1)
- Pega (6)
- Micro Biology (2)
- Bio Chemistry (1)
- Bio Informatics (50)
- Genetics (1)
- Biological Sciences AllOther (1)
- Inorganic Chemistry (2)
- Physical Chemistry (2)
- General Chemistry (2)
- Pharmacy (1)
- Dermatology (1)
- Gynaecology (1)
- Mathematics (14)
- Civil Engineering (3)
- Mechanical Engineering (16)
- Electrical Engineering (79)
- Electronics Communications (63)
- Aeronautical Engineering (1)
- Bio Engineering (2)
- Instrumentation (3)
- Engineering AllOther (26)
- Business Administration (11)
- Marketing Sales (11)
- Banking Finance (23)
- Human Resources (19)
- Personnel Management (1)
- Infrastructure Management (1)
- IT Management (3)
- Non Technical (2)
- Audit (7)
- CompanyAffairs CS (3)
- Taxation (27)
- Accounting General (44)
- Accounting AllOther (86)
- Advertising Media AllOther (1)
- Call Centre AllOther (311)
- UPSC Political Science (1)
- UPSC History (1)
- UPSC General Studies (2)
- UPSC AllOther (1)
- SSC Geography (1)
- SSC General Science (1)
- SSC General Studies (3)
- SSC AllOther (9)
- RRB (7)
- CDS (1)
- POs (5)
- BSRB Clerical (4)
- BSRB AllOther (1)
- Group I (12)
- Group II History (6)
- Group II AllOther (4)
- APPSC AllOther (13)
- General Knowledge_Current Affairs (30)
- Government AllOther (10)
- Law AllOther (1)
- Teaching (5)
- Funny Interview Questions (5)
- Everything Else AllOther (19)
- English (20)
- General Aptitude (190)
- Puzzles (21)
- Placement Papers (31)
- CCNA (47)
- Microsoft Certifications (15)
- Sun Certifications (2)
- CISA Certification (1)
- Oracle Certifications (4)
- Certifications AllOther (3)
- H1B Visa (8)
- USA Student Visa F1 Visa (2)
- L1 Visa (1)
- USA Visitor Visa B2 Visa (2)
- USA Business Visa B1 Visa (1)
- USA Dependent Visa H4 Visa (6)
- USA AllOther Visa (1)
- UK Visa (1)
- Australia Visa (2)
- Canada Visa (1)
- C Code (20)
- C++ Code (3)
- J2SE Code (1)
- ASP.NET Code (2)
- C Sharp Code (2)
- Visual Basic Code (1)
- Programming Code AllOther (1)
- PHP Code (2)
- JSP Code (1)
- JavaScript Code (1) VB Script Code (1)
- GATE (5)
- CAT (1)
- MAT (1)
- GMAT (3)
- AIIMS (1)
- ICET (4)
- C C++ Errors (2)
- Oracle Errors (9)
- SQLServer Errors (1)
- Scripts Errors (2)
