User`s guide

254 VEE User’s Guide
6 Creating Reports Easily Using ActiveX Chapter
Using CreateObject and GetObject
Notice that one of the statements in Set Up Excel Worksheet in
Figure 148 contains the CreateObject() function call.
CreateObject() and GetObject() are functions in the VEE
Function & Object Browser, and they are designed
specifically to return a pointer to an ActiveX object in VEE.
For example, CreateObject("Excel.Sheet")starts up Excel and
returns a reference to a workbook in it. (The Microsoft
statement “sheet” returns a workbook.) Use GetObject() to
get something or some data that already exists in a running
Excel, or to load a file into a running Excel.
CreateObject and GetObject are located under Device ⇒
Function & Object Browser, Type: Built- in Functions, Category:
ActiveX Automation. Figure 149 shows an example
CreateObject and GetObject.
Figure 149 CreateObject and GetObject