How to use VBA to control RUMBA 7.2 using ActiveX controls?

[oliverrice]

Hey,

I've been searching the internet for days trying to work out how to control (screen scrape) RUMBA mainframe using VBA. I have found a few hints and tips but nobody seems to have posted any sample code that I can interrogate and adapt.

Does anybody here know how to automate RUMBA using VBA? Main functions I need are:

- Test fields in RUMBA for certain data
- Capture information from RUMBA and use it within the VBA code
- Paste information from VBA into RUMBA

I have discovered the activeX controls built into this mainframe and I have added them as references to my VBA. The problem I have is that I dont know how to use these properly and I cant find any help on the internet. If anybody here can help me out I would greatly appreciate it?

If anybody could help, this would be great!

Oliver

 

[Qik3Coder]

Is there a particular reason you're using VBA instead of something else?

Screen scraping is painful enough without having access to easy string manipulation, data type checking and arrays.

Without the debugger attached from Visual Studio, you don't get intellisense. This is the only way I've found to inspect an object without documentation.

You've got questions and source code. We want both!