This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Fetch an active MicroFocus Rumba Object in VBA

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?.

Tags:

Labels:

Rumba