Skip to main content

Hi All,

I am new to forum. I am a starter for VBA macros in Rumba. 

I have a existing macro which is used to enter transactions on CICS screens. I input data from excel and after transaction is complete write the error message to output file. 

Now as of the reporting I need to capture screen shots in word document.

 When I record a macro and capture the screen shot, the screen capture commands are not recorded.

 I get the Emulation “TN3270” command and CICS screen commands.

 Is it possible to append screen shots to word documents using VBA or other language.

 Also how can I get the emulator objects (specific to Host explorer).

Is there any way I can create a VBS file to capture screen shots. 

Regards,

Naveen n


#Rumba

Hi All,

I am new to forum. I am a starter for VBA macros in Rumba. 

I have a existing macro which is used to enter transactions on CICS screens. I input data from excel and after transaction is complete write the error message to output file. 

Now as of the reporting I need to capture screen shots in word document.

 When I record a macro and capture the screen shot, the screen capture commands are not recorded.

 I get the Emulation “TN3270” command and CICS screen commands.

 Is it possible to append screen shots to word documents using VBA or other language.

 Also how can I get the emulator objects (specific to Host explorer).

Is there any way I can create a VBS file to capture screen shots. 

Regards,

Naveen n


#Rumba

Hi and welcome to the RUMBA Forum.

In Rumba Scripting (VBA) you can automate your requested tasks.
In our upcoming RUMBA Version 9.5 we added Microsoft VBA.
With the new upcoming VBA Addon you are able to automate Rumba from your Microsoft Applications (Excel , Word, Access ...).

Find below a quick & dirty example rumba script example. They're better ways to take screenshots but It should  give you the basic idea.
The example opens RUMBA , connects to a CICS Transaction, takes a screenshot , opens a word document and saves the the word document.

 

cheers

/andre

Hi All,

I am new to forum. I am a starter for VBA macros in Rumba. 

I have a existing macro which is used to enter transactions on CICS screens. I input data from excel and after transaction is complete write the error message to output file. 

Now as of the reporting I need to capture screen shots in word document.

 When I record a macro and capture the screen shot, the screen capture commands are not recorded.

 I get the Emulation “TN3270” command and CICS screen commands.

 Is it possible to append screen shots to word documents using VBA or other language.

 Also how can I get the emulator objects (specific to Host explorer).

Is there any way I can create a VBS file to capture screen shots. 

Regards,

Naveen n


#Rumba
Thanks You, the response help me a lot!!

Hi All,

I am new to forum. I am a starter for VBA macros in Rumba. 

I have a existing macro which is used to enter transactions on CICS screens. I input data from excel and after transaction is complete write the error message to output file. 

Now as of the reporting I need to capture screen shots in word document.

 When I record a macro and capture the screen shot, the screen capture commands are not recorded.

 I get the Emulation “TN3270” command and CICS screen commands.

 Is it possible to append screen shots to word documents using VBA or other language.

 Also how can I get the emulator objects (specific to Host explorer).

Is there any way I can create a VBS file to capture screen shots. 

Regards,

Naveen n


#Rumba
I was able to get the screen shot pasted on the word document.
Terms & ConditionsAccessibility statement