Skip to main content

Hi All,

I want to connect and work with Rumba WebToHost Pro client using excel macros, i.e. I want to enter values, send keys like Escape or Enter or F4 keys and also read values from mainframe screen using excel macro(vba).

  • Vendor: NetManage
  • Emulator: WebToHost Pro Client (Version 5.3.1)

Could you guys please help me by sending a sample excel macro code to connect WebToHost Proclient using excel, then enter some values in mainframe and reading values from it?

Note:

I tried to look in to sample macro in my machine, but the folder is empty and the "Tools" menu is not available/visible in WebToHost Proclient application toolbar.


#API
#Rumba
#WebToHostProClient
#Script
#Macro
#Excel
#Netmanage
#toolbars
#macros
#macrorumba
#Vba
#ExcelorVBACode

Hi All,

I want to connect and work with Rumba WebToHost Pro client using excel macros, i.e. I want to enter values, send keys like Escape or Enter or F4 keys and also read values from mainframe screen using excel macro(vba).

  • Vendor: NetManage
  • Emulator: WebToHost Pro Client (Version 5.3.1)

Could you guys please help me by sending a sample excel macro code to connect WebToHost Proclient using excel, then enter some values in mainframe and reading values from it?

Note:

I tried to look in to sample macro in my machine, but the folder is empty and the "Tools" menu is not available/visible in WebToHost Proclient application toolbar.


#API
#Rumba
#WebToHostProClient
#Script
#Macro
#Excel
#Netmanage
#toolbars
#macros
#macrorumba
#Vba
#ExcelorVBACode

We were using Seagull and BlueZone in my last account to connect to mainframe and we use the below vba or excel macro code to automate it

Rem===Create Bluezone Object===

Set g_objBlueZone = CreateObject("Bzwhll.Whllobj")

Rem===Create Session===

Set g_objSession = g_objBlueZone.ActiveSession

Set g_objScreen = g_objSession.Screen

Rem==Enter Value in Mainframe dispay===

g_objBlueZone.WriteScreen strValue, IntRow, intColumn

Rem==Wait for mainframe===

g_objBlueZone.WaitReady 1, 200

Rem==Read value from mainframe===

g_objBlueZone.ReadScreen strReadValue, intLength, intRow, intColumn

Please help me to

  • 1. Create an object for Rumba WebToHost Pro Client 5.3.1 to access the mainframe screen using excel macro.
  • 2. How to enable macro option in Rumba WebToHost Proclient?

#Vba
#Excel
#macros
#macrorumba
#toolbars
#API
#Macro
#Script
#WebToHostProClient
#Netmanage