Does anyone know how to link MS Excel to Attachmate Mainframe Session! Extra or vice-versa?

Objectives are:

1. Input data on specific cell in Excel and those data will automatically transfer to target screen location in Attachmate Mainframe.

2. Data on specific screen location in Attachmate Mainframe will be automatically be copied.

3. Copy specific Attachmate Mainframe screen and paste it to Excel as TEXT rather than a picture.

4. Save macro in Attachmate Mainframe without it being deleted after the application was closed. (Since saved recorded macro in Attachmate Mainframe are being deleted after the application was reset or closed).

I hope you could help me on this one. I really need help.

Thanks!