Copy data from reflection screen to excel sheet

Hi,

Please follow the instructions on this HowTo document:

https://www.microfocus.com/documentation/reflection-desktop/17-1/vba-guide/get-screen-data-with-excel.html

Of course this is just an example and you have to adapt this macro in order to navigate to the desired screen in your mainframe environment.

Is there an updated link for this how-to? The link is giving a 404 error. 

Thank you, 

VBA examples for Secure Host Access are available in the official Rocket Software documentation.

You can download a ZIP archive containing various VBA examples from here:
https://docs.rocketsoftware.com/bundle/securehostaccess_vba_samples/resource/securehostaccess_vba_samples.zip

The ZIP includes multiple samples. One notable example is get-ibm-screen-data-with-an-excel-macro.xlsm, which demonstrates how to use Microsoft Excel VBA to automate Secure Host Access Pro (Desktop) and retrieve screen data from an IBM host session.

In addition, you can download the VBA Reference Guide from:
https://docs.rocketsoftware.com/bundle/securehostaccess_vba_rg_2510/resource/securehostaccess_vba_rg_2510.zip

This ZIP contains:

• The VBA reference documentation
• A compiled help file (.chm)
• Explanations of the provided examples and the available VBA APIs

Together, these downloads provide both working VBA samples and the official documentation needed to understand and extend them.

For Reflection 18.x