Mainframe Access User Discussions

Home

Verified Answers

If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it!  Learn more

State Suggested Answer
Replies replies
3
Answers answer
1
Subscribers subscribers
9
Views views
1698
Users 0 members are here
Locked Locked

Related

Options

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

How to automate rumba through Excel VBA

Gowrisankar over 4 years ago

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

Tags:

automate

RUMBA

VBA

Labels:

Vba

Automate

Rumba

Rumba

0 ztalpur over 4 years ago

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.
Cancel
Vote Up 0 Vote Down

Cancel
0 Samantha Stone over 2 years ago in reply to ztalpur

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?.
Cancel
Vote Up 0 Vote Down

Cancel
Suggested Answer

0 andree over 2 years ago in reply to Samantha Stone

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

Cancel

Resources

Learning Services

Partner Programs

Privacy

Compliance

Help

Company

Privacy Policy
Terms of Use
Cookies Preferences

Accessibility
Anti-Slavery Statement

Support
Contact Us

Careers
Code of Business Conduct and Ethics

The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.