Connecting to Rumba using VBA

Hi Nisarg,

you need to reference the Control to your project. in Excel VBA Developer go to Tools -> References.
Or you can use a UserForm to place the Rumba Control

UserForm

Hi Andre,

I have selected ObjectX Mainframe Display Control from Tools -> References using WdMfDsp.Tlb file as mentioned in the post.

Hi Andre,

I have selected ObjectX Mainframe Display Control from Tools -> References using WdMfDsp.Tlb file as mentioned in the post.

Hi Nisarg,

simply adding the reference is not enough, you need to create an instance of a control. In the sample you pointed too, it was using a control embedded on a user form with several buttons.

So the sample solution look like this when executed.

Tom

Is there an AS400 equivalent of "Wd??Dsp.tlb" to use in Exel/Access VBA?

Is there an AS400 equivalent of "Wd??Dsp.tlb" to use in Exel/Access VBA?

Hi elcron,

there is no .tlb file for the AS400, however you should be able to add a reference to WDAS4DSP.OCX and then you should have a AS400 display terminal control available for selection in your toolbox.

I note there is an issue with RUMBA 9.4, where trying to execute a form with an embedded AS400 terminal causes VBA to crash. If you are using RUMBA 9.4 you should open a support incident whit Customer Care, so we can have development  address the issue.

Tom

Hi elcron,

there is no .tlb file for the AS400, however you should be able to add a reference to WDAS4DSP.OCX and then you should have a AS400 display terminal control available for selection in your toolbox.

I note there is an issue with RUMBA 9.4, where trying to execute a form with an embedded AS400 terminal causes VBA to crash. If you are using RUMBA 9.4 you should open a support incident whit Customer Care, so we can have development  address the issue.

Tom

Thanks, is there any documentation on WDAS4DSP like how to pass data to and from this object like keystrokes and screen grabs?

Hi elcron,

yes there is some documentation, unfortunately it appears to be part of the Rumba Developer Edition bundle, which I understand is a add on to Rumba. You should contact support line to see if a copy of the WDHost.chm can be provided to you.

Note: Looking through the documentation, it appears as if most of the WDAS4DSP.OCX method call are of the same structure.

e.g. SendKeys, PutScreen, PutScreen2, GetScreen, GetScreen2 are the same.

Also you have read/Write access to the cursor location via the CursorRow & CursorColumn properties.

My advice would be to use the WdMfDsp.tlb as a guide until you can get your hands of a copy of WDHost.chm.

Tom

Hi elcron,

yes there is some documentation, unfortunately it appears to be part of the Rumba Developer Edition bundle, which I understand is a add on to Rumba. You should contact support line to see if a copy of the WDHost.chm can be provided to you.

Note: Looking through the documentation, it appears as if most of the WDAS4DSP.OCX method call are of the same structure.

e.g. SendKeys, PutScreen, PutScreen2, GetScreen, GetScreen2 are the same.

Also you have read/Write access to the cursor location via the CursorRow & CursorColumn properties.

My advice would be to use the WdMfDsp.tlb as a guide until you can get your hands of a copy of WDHost.chm.

Tom

Hi,
I refered to the same forum to write an application to connect to Rumba, I am not not finding ObjectXConfigureTn3270Link type. Which OCX or reference i need to add to get this type.

https://community.microfocus.com/microfocus/mainframe_solutions/rumba/f/12/p/13119/23410.aspx#23410

Could you please tell me what i have missed..? I have added Active X main frame display control.

Hi,
I refered to the same forum to write an application to connect to Rumba, I am not not finding ObjectXConfigureTn3270Link type. Which OCX or reference i need to add to get this type.

https://community.microfocus.com/microfocus/mainframe_solutions/rumba/f/12/p/13119/23410.aspx#23410

Could you please tell me what i have missed..? I have added Active X main frame display control.