CreateObject is function which creates a reference to the specified
object. You can then use the reference object to access the methods/properties
of the specified object.
As createobject returns a reference to object, you must use
Set to assingn it to a variable.
Set objExcel=CreateObject(“Excel.Application”)
‘Adding a workbook
Set objWorkBooj= objExcel.Workbooks.Add
‘Activating the sheet
Set objSheet=objWorkBook.Worksheets("Sheet1")
‘Writing values to excel
objExcel.Cells(row,column)=<”Your value>”
Below is the list of most commonly used objects. I hope you find it useful.
S.No
|
Object
|
Description
|
1
|
Set
ObjectName= CreateObject("Wscript.shell")
|
Provides
access to the native Windows shell. Provides functions to read system
information and environment variables, to work with the registry and to
manage shortcuts.
|
2
|
Set
ObjectName = CreateObject("WScript.Network")
|
Provides
access to the shared resources on the network to which the computer is
connected.
|
3
|
Set
ObjectName = Createobject("Excel.Application")
|
Perform
operations on MS Excel.
|
4
|
Set
ObjectName = CreateObject("Word.Application")
|
Perform
operations on MS Word.
|
5
|
Set
ObjectName = CreateObject("Outlook.Application")
|
Perform
operations on MS Outlook.
|
6
|
Set
ObjectName = CreateObject("InternetExplorer.Application")
|
Perform
operations on Internet Explorer.
|
7
|
Set
ObjectName = Createobject("QuickTest.Application")
|
Perform
operations on Quick Test Professional (QTP).
|
8
|
Set
ObjectName = CreateObject("QuickTest.UpdateRunOptions")
|
A
collection of properties that indicate preferences for the Update Run in QTP.
|
9
|
Set
ObjectName = CreateObject("QuickTest.RunResultsOptions")
|
A
collection of properties that indicate preferences for the run results in
QTP.
|
10
|
Set
ObjectName = CreateObject("Scripting.FileSystemObject")
|
To
work with the Windows file system structure: files, folders, drives.
|
11
|
Set
ObjectName = CreateObject("Mercury.DeviceReplay")
|
Perform
mouse or key operations exactly as they occur on the mouse or keyboard
drivers.
|
12
|
Set
ObjectName = CreateObject("Mercury.ObjectRepositoryUtil")
|
Perform
an operation on QTP Object Repository.
|
13
|
Set
ObjectName=CreateObjcet("Scripting.Dictionary")
|
Creates
a dictionary object
|
14
|
Set
ObjectName=CreateObject("vbScript.RegExp")
|
Creates
a regular expression object
|
15
|
Set
ObjectName = CreateObject("Mercury.FileCompare")
|
To
compare two files.
|
14
|
Set
ObjectName = CreateObject("Mercury.Clipboard")
|
Perform
clipboard functionality.
|
15
|
Set
ObjectName = CreateObject("Msxml2.DOMDocument")
|
Creates
a DOMDocument object to perform operations related to XML document.
|
16
|
Set
ObjectName = DotNetFactory.CreateInstance (TypeName [,Assembly] [,args])
|
Returns
a COM interface for a .NET object.
|
17
|
Set
ObjectName = Createobject("shell.application")
|
To
instantiate the Shell object, to program the Shell which can be used to
access the file system, to launch programs, and to change system settings.
|
18
|
Set
ObjectName= Createobject("TDApiOle80.TDConnection.1")
|
An
object that enables to manage the Quality Center connection and retrieve the
TDOTA object, which provides full interaction with Quality Center.
|
19
|
Set
ObjectName = CreateObject("Microsoft.XMLDOM")
|
To
access and manipulate XML documents via the XML DOM implementation, as
exposed by the Microsoft XML Parser.
|
20
|
Set
ObjectName = XMLUtil.CreateXML()
|
Creates
and returns an object of type XMLData. If a root name is specified, a new
document is created containing the specified root tag.
|
21
|
Set
ObjectName = CreateObject( "AcroExch.App")
|
Acrobat OLE Automation
Objects.
|
Set
ObjectName = CreateObject( "AcroExch.AVDoc")
|
||
Set
ObjectName = CreateObject( "AcroExch.PDDoc")
|
||
Set
ObjectName = CreateObject( "AcroExch.HiliteList")
|
||
Set
ObjectName = CreateObject( "AcroExch.PDBookmark")
|
||
Set
ObjectName = CreateObject( "AcroExch.Rect")
|
||
22
|
Set
ObjectName = CreateObject("ADODB.Connection")
|
Creates
an instance of the ADO connection to connect to database.
|
23
|
Set
ObjectName = CreateObject("ADODB.Recordset")
|
Creates
an instance of the recordset object. To be able to read database data, the
data must first be loaded into a recordset.
|
24
|
Set
ObjectName =CreateObject("msscriptcontrol.scriptcontrol")
|
Perform
operations to MS Windows Scripting Engine.
|
25
|
Set
ObjectName = CreateObject("SAPI.SpVoice")
|
Auditory
voice feedback during a test run, done by utilizing the Microsoft Speech API.
|
26
|
Set
ObjectName = CreateObject( "UserAccounts.CommonDialog")
|
Object
to provide users with a standard File Open dialog box
|
27
|
Set
ObjectName = CreateObject("CDO.Message")
|
Windows
CDO object is suitable for creating and sending automated emails.
|