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?
1843Post New Wipro VB Script Code Interview Questions
i want to learn mainframe..any websites and material to learn from basic..? my mail id : rajeswaribe2010@gmail.com
online demo for bug tracker tool(let me know the website)
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
How to Create a Dashboard?
What are the ways tablespaces can be managed and how do they differ?
in basic 2 phase will short means tripping the power but spot welding 2 phase shorting but not tripping it will welded why.....(Q)
WHY DO VOLTAGE TRANSFORMERS FAIL DURING EARTH FAULT IN THE DELTA CONNECTED 6.6KV ELECTRICAL SYSTEM
Contaminants of fuel oil
How do you see the future of multimedia in India?
How i can calculate material for 1000 sq foot plot.
What is modbus, profibus, fieldbus
what is call handover?
Why squirrel cage motor can only use with low starting loads ?
what are the basic parameters of a Mapper?
how to reuse an outdated laptop?
- C (153)
- STL (10)
- OOPS (37)
- C++ General (30)
- MFC (5)
- COM DCOM (1)
- Win32API (1)
- Delphi (4)
- PHP (13)
- Programming Languages AllOther (18)
- 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 (13)
- Visual Basic (14)
- C Sharp (51)
- ASP.NET (61)
- VB.NET (2)
- ADO.NET (9)
- IIS (7)
- Crystal Reports (2)
- Dot Net Framework (4)
- Dot Net WindowsForms (12)
- Dot Net General (21)
- Dot Net AllOther (2)
- Exchange Server (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 (91)
- 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 (34)
- 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)
- Micro Biology (2)
- Bio Chemistry (1)
- Bio Informatics (49)
- Genetics (1)
- Biological Sciences AllOther (1)
- Inorganic Chemistry (2)
- Physical Chemistry (2)
- Pharmacy (1)
- Dermatology (1)
- Gynaecology (1)
- Mathematics (2)
- Civil Engineering (3)
- Mechanical Engineering (16)
- Electrical Engineering (79)
- Electronics Communications (62)
- 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 (310)
- 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 (106)
- 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)
