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#ExcelorVBACodeWe 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