Software Testing and QTP Complete Tutorials and Interview Questions: How to Open an Excel Spreadsheet in Vbscript

Set objExcel = CreateObject("Excel.Application")
Set objWorkbook = objExcel.Workbooks.Open("C:\Scripts\New_users.xls")

Select Your Topic Here

QTP

Introduction to Automation
QTP introduction
Starting QTP
Different Panes and Menu Commands in QTP
Testing Process in QTP
Recording and Running tests
Difference b/w recording methods
Running and analyzing results
Creating scripts Using Key word view
Object Identification introduction
Object repository
Different options in Object Repository
Test Objects
Runtime Objects
Difference b/w TO & RO properties
Object Spy
Object Identification Configuration
Difference b/w identification methods
Local Object Repositories
Shared Object Repositories
Object Repository manager
Role of repository manager in QTP
Creating Shared Object Repositories
Virtual Objects
Check Points
Creating own check points
Synchronization Point
Actions
Reusable Actions
Parameterization
Output Values
Libraries
Creating Libraries
Associating Libraries to test
Step Generator
Writing Scripts Using Step Generator
Calling Functions Using Step Generator
Transactions
Need of Transactions
Recovery Scenario
Need of RSM
Regular Expressions
Advantages of Regular Expressions
Debugging in QTP
Descriptive Programming
Descriptive Programming in Real time
Defining Automation Scenarios
Creating Frame Work
Using Automation Object Model
Making HTML format Results
New Features in QTP 10

VBScript

VBScript Introduction
VBScript Data Types
Conversion Functions
VBScript Variables
VBScript Constants
VBScript Operators
VBScript Statements
vbscript comments
Control Structures
VBScript Arrays
VBScript Procedures
Passing Arguments
Variable Scope
Inbuilt Functions
Error Handling
Windows Scripting
WMI Object

Quality Center

VSS

Software Testing and QTP Complete Tutorials and Interview Questions

Pages

Search here for all the info you want in this Blog

How to Open an Excel Spreadsheet in Vbscript

No comments:

Post a Comment