• excel 365 32bit VBA to Rumba 10.1

    Greetings! I am a beginner here. I have searched the website best I can, but I have not found anything as specific as I really need it. I'm not certain which references I need to check off to make a connection, and I'm not certain of a good template…
  • Copy data from reflection screen to excel sheet

    Hello Team, Good day! I need help with refelection - excel vba macros automation. In our project we want to navigate to specific screen in reflection workspace application and copy all the needed data from that screen to excel sheet by using excel…
  • Accessing and using "regular" Office/Word/Excel/Outlook/etc. objects from a Reflection VBA macro?

    Hi, I've been building some macros via the VBA editor available in InfoConnect Desktop, and would like to be able to invoke/use Microsoft's "FIleDialog" control (documented here: https://docs.microsoft.com/en-us/office/vba/api/Office.FileDialog ) to…
  • Save all screenshots from Screen History in Reflections V17

    Currently, I have a lot of scripts that run from excel in order to scrape data from TSYS. Is there a way to access the screenshots from the screen history? I am using GetObject("RIBM") in order to control the emulator, but currently stuck on what…
  • Updating Excel VBA Attachmate Extra macros to Reflection Desktop

    Hello. I have developed numerous Excel VBA macros in Windows 10 that read and write data between an Excel workbook and a 3270 terminal opened with Attachmate Extra. I've been forced to upgrade to Reflection and now need to update all these macros. With…
  • vba to copy data in reflection from excel

    HI Team, I using "Micro Focus Reflection Desktop (16.2.839.0)" want vba to copy excel data to terminal screen. please help.
  • How to automate rumba through Excel VBA

    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…
  • Automate FTP Connection with VBA

    Hello, I have been trying to connect to some outside servers using VBA with Rumba FTP Client 4.4 but have been unable to successfully do so. I can create the connections using the GUI, but receive an error 500 when I try to do this with the same setting…
  • Manipulating Rumba Edit Settings via VBA

    Good day, Everybody! I'd like to know if there was a way to manipulate/override/ignore Edit settings in Rumba via VBA code. Some of our users have the "Paste Insert" Edit setting checked, and that has been messing with our VBA macros that try to send…
  • Connecting to Rumba using VBA

    Hi, I am trying to connect to Rumba using VBA code posted in Rumba forum here: community.microfocus.com/.../23410.aspx But I am getting " Run-time error '424': Object Required " at this line: ObjectXMFDisplay1.HostInterface.Name = "WallData…
  • EMSendKey and EMSendKeyFast difference

    Hello everyone, I'm using rumba 7.5.1 (yes it's old but I cannot change it) and I do not understand well the difference betweet EMSendKey and EMSendKeyFast. I understand that one is "fast" and the other not, but if I check the function description I do…
  • RE: Sample Excel Macro code for Rumba WebToHost Pro client

    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===…
  • Sample Excel Macro code for Rumba WebToHost Pro client

    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 …
  • VBA macro to connect Excel and Rumba

    Hello - My organization uses Rumba version 7.5.1 and i am trying to write a VBA macro to connect Microsft Excel to Rumba so that i can copy/paste information to/from Excel and rumba. Here is the code i used - Private Declare Function WD_ConnectPS Lib…