Sample Excel Macro code for Rumba WebToHost Pro client

Forum|Forum|11 years ago
October 8, 2014
1 reply
0 views

Dominique Sacre
Rocketeer

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

D

Dominique Sacre
Author
Rocketeer
Forum|Forum|11 years ago
October 8, 2014

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?