Create a script to automate a repetitive task in Terminal Emulator

Hi,

I am new to this forum, our shop uses Rocket TE Mainframe Display v10.2.1. I have a repetitive task I need to perform it for thousands of entries.

I have an excel spreadsheet containing a huge number of accounts. I need to do the below steps for all the accounts in that list. Just wanted to check if there is anyway to automate this in Rocket instead of doing this manually for all entries in the excel sheet. Firstly, I log into a CICS region and launch a transaction ABCD. We do not have VBA supported license I believe, however I can bring that list of accounts into a PS FILE in Mainframes, it is just another session I need to switch using PF21 key.

1. Copy the account from spreadsheet/ PS File in the Mainframe ISPF session.
2. PF21 key to switch to CICS session
3. Hit Enter
4. Enter command COM1
5. Hit Enter
6. Change I to M
7. Hit Tab
8. Enter the account number from the step 1
9. hit PF5 key
10. Repeat steps 1 through 5 for all the remaining accounts. If the solution uses the ISPF session, then need to press PF8 key to get the next list of accounts.