I am using MicroFocus Rumba (VBA Addon) in a VBA project. On the Excel workbook open event, Rumba is opened, and activated (it is declared as a global object). User also opens another instance of Rumba to verify the details.
When "End" is clicked/executed on a Excel Macro, Rumba instance object associated with it gets destroyed. And I need to re-initiate it to be able to run rest of the process. For this purpose I am using GetObject(,"MicroFocus.Rumba") but it does not work and throws an error "ActiveX cant create component", I believe its because it was created in VB(not sure)??.
Is there any workaround for it? or other approach to capture the active object?.