An example on how to use GetObject on custom made ActiveX EXE. (And Microsoft said that it cannot be done :-))
This sample will teach you how to expose classes from an ActiveX EXE to other Applications. I felt that a Main App / Plugin relationship (like in Photoshop) will be best suited to showcase this cool solution.
This is how it works:
When an object gets created based on a class from an ActiveX Exe it gets created in its own memory area (Multiple objects based on the same class cannot share their data). In C++ that object registers itself with the ROT (Running Object Table) so that anybody who needs to, can access that instance of the object. For instance Excel. When Excel is running you can refer to the running instance from VBA/VB, and access any data that’s present in the spread sheet. However VB based objects lack that functionality. Activex EXE created in VB will NOT get registered in the ROT! (That’s why you can’t use GetObject on VB made ActiveX’s ;-) )
Anyhow, here is a solution that will register your ActiveX EXE in the ROT, and you will be able to reference the running instance of your object from any other application.
Please use this sample as follows:
The benefits: If you expose your app’s objects up front, you can later on create any plugins/addons you want without modifying the original app.