Skip to main content

Dear members of the forum,

I'm trying to automate Rumba mainframe through Excel VBA. I'm quite new to this.

I tried the following code to open mainframe application but it throws "ActiveX component Can't create object" error.

Dim oSys As Object

Set oSys = CreateObject("rumba.system")

 

Can you please guide? If you have existing code samples, that would be very helpful for me to understand and proceed further.

Note : I'm using MicroFocus Rumba Desktop 9.4.1


#Automate
#Vba
#Rumba

Dear members of the forum,

I'm trying to automate Rumba mainframe through Excel VBA. I'm quite new to this.

I tried the following code to open mainframe application but it throws "ActiveX component Can't create object" error.

Dim oSys As Object

Set oSys = CreateObject("rumba.system")

 

Can you please guide? If you have existing code samples, that would be very helpful for me to understand and proceed further.

Note : I'm using MicroFocus Rumba Desktop 9.4.1


#Automate
#Vba
#Rumba

Hi Gowrisankar,
Are you using 32 bit or 64 bit Excel? Our current version of Rumba is 10 and 10.1 is releasing soon. Please note that Rumba 9.4.1 support expired on 31st of Aug 2020.

Please let me know if you've any questions.

 


Hi Gowrisankar,
Are you using 32 bit or 64 bit Excel? Our current version of Rumba is 10 and 10.1 is releasing soon. Please note that Rumba 9.4.1 support expired on 31st of Aug 2020.

Please let me know if you've any questions.

 

Hi - I do not see "ObjectX Mainframe Display Control" on Excel 365 64 bit while trying to add a Mainframe emulator. It is working with Excel 2013 32 bit. I also manually registered .ocx control on my windows 64 bit pc. Please assist. Is there a substitute control or a 64 bit version of Rumba +Desktop 10.1?. 


Hi - I do not see "ObjectX Mainframe Display Control" on Excel 365 64 bit while trying to add a Mainframe emulator. It is working with Excel 2013 32 bit. I also manually registered .ocx control on my windows 64 bit pc. Please assist. Is there a substitute control or a 64 bit version of Rumba +Desktop 10.1?. 

see suggested answer: under (+) ObjectX Mainframe Display control missing in Excel 365 64 bit - Rumba - Forum - Rumba (microfocus.com)