What is the diff between the Create Object and Get object?
Answer Posted / abcd
1. CreateObject creates an instance of a class
2. GetObject gets the reference of an running object
to another object
3. Always use CreateObject except for Windows
Management Instrumentation (WMI) and Active Directory
Service Interfaces (ADSI)
The below script demonstrates the use of these two VBScript
functions.
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
Set objWorkbook = objExcel.Workbooks.Add
Set objExcel2 = GetObject(, "Excel.Application")
Set objWorkbook = objExcel2.Workbooks(1)
Set objWorksheet = objWorkbook.Worksheets(1)
objExcel2.Cells(1, 1).Value = "In god I TRUST everything
else I TEST."
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Types of LockEdits in DAO?
How do I use GetPrivateProfileString to read from INI files?
What is the difference between c++ and visual basic?
What is the need of tabindex property is label control.
OLE is used for _______
How do I get the number of free bytes on a disk?
what are the types of cursors in DAO?
Can you create a tabletype of recordset in Jet - connected ODBC dbengine?
what are the Types of DBCombo boxes?
Can you create a updatecascade, Deletecascade relation in Ms- Access? If no, give on eample.
Which type of object requires this object?
Is there any Edit method in ADO Data Access method?
How do I add a form in visual basic?
What is hyperlink?
What is the latest version of visual basic?