My requirement is to add new 139 error codes and its description.
Error codes is present in column A of the excel sheet.
Error description is present in column B of the excel sheet.
I have to copy the error code and its description from excel and paste it in
mainframe online CICS screen and hitting the ADD action code (A).
My senior did one macro (or Vb script?). This macro will automatically switch to excel ,copy the error code from excel and again swith to mainframe screen
and add it. It is processing row by row from the excel sheet and processing continues until all codes present in excel are added.
I thought to ask him. But unfortunately he is unable to contact.
The way you describe it, it is most certainly a vb script executed in the mainframe emulation program.
If you use IBM Personal Communications emulator, then you can try to record a macro that does the Add and Paste thing.
(check that it is recorded as a VBScript file, not a macro file).
Then you will have to manually edit this script to add the Copy from Excel.
And then add (manually again) the loop part.
For other emulators, there is certainly a similar option, but in all cases I'm afraid you will have to do some vb scripting.
Thanks for your reply. I also thought it is a VB script.
Of course, the easiest way is:
1. Save the Excel document as a CSV file.
2. Transfer the file to the Mainframe.
Here i dont want to copy the contents from excel file to PS or PDS file.
I want to copy the error code row by row from excel and paste it in CICS online screen. Here the screen will allow to add one error code at a time and no option to add all error codes at one shot.
So if i want to manually add 139 error codes, i have to press ALT+TAB between excel and mainframe 139 times.