Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diff between the Create Object and Get object?
- 2 Answers
- 15091 Views
- I also Faced
- E-Mail Answers
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
What are the properties of datacontrol?
How do I create a window with a small title bar as in a floating toolbar?
___,_____ and ____ container objects.
Hi, I am USINg QTP tool for automation. Where VB Script have to use. I want to read a row from the table present in .Doc File and to paste in excel. Could you please assist me or give me the code to get it. I am new in this technology.
What is the need of tabindex property is label control?
What are the tools available for Debuggiu in VB?
How should dates be implemented so they work with other language and country formats?
What is the current version of Visual Basic for Windows?
Is it possible to Access BackEnd procedures? Explain.
How many ways you can access file using VB?
Explain the types of Views in Listview Control?
What are the types of line styles available in Treeview Control?
What is vbs file?
It possible to call OLEDB's Features directly in VB without using any control?
Explain Default cursor Type and LockEdit type in DAO?
