The ActiveX procedures allow the application to use Microsoft ActiveX™/COM (Component Object Model) controls and objects that are installed in your machine. These objects can be used to access external software components such as Microsoft Excel, Data Base, controls such as TreeView or Calendar, etc. The ActiveX procedures provide a way to create an object or to open existing one.
CreateObject creates a new COM object and the GetObject function is to retrieve an exiting active COM object or a COM object created from a file. The created object is set the a variable declared as an generic object data type (Object) or a class declared in a type library added to the libraries sub-module (i.e. Excel.Sheet).
After the object is retrieved or created ATEasy allows you to set or get its properties or call its methods. When the object is no longer needed, the application can delete it and free its system resources by assigning Nothing to the object variable.