Hello everyone,
I am currently using Excel to gather some data from our Mainfram systems. We are using Extra 6.71 as the Mainframe emulator. Using VBA, I am able to connect to Extra and then use the Function "SendKeys" to get to a specific screen on the mainframe.
The problem however lies when I'm using the function "GetString" (Which should be reading a string from the screen as a given position).
The string I see on the screen is : "JCLEDIT"
The string returned by the GetString function is : "ÑÃÓÅÄÉã"
The ASCII Codes of the string returned by GetString are : 209,195,211,197,196,201,227
After much fooling arround, I realized that those codes are actually the EBCDIC codes of "JCLEDIT"
Anybody knows how to have GetString do the conversion automatically?
If not, what would be a good algorithm to convert EBCDIC to ASCII?
I am currently using Excel to gather some data from our Mainfram systems. We are using Extra 6.71 as the Mainframe emulator. Using VBA, I am able to connect to Extra and then use the Function "SendKeys" to get to a specific screen on the mainframe.
The problem however lies when I'm using the function "GetString" (Which should be reading a string from the screen as a given position).
The string I see on the screen is : "JCLEDIT"
The string returned by the GetString function is : "ÑÃÓÅÄÉã"
The ASCII Codes of the string returned by GetString are : 209,195,211,197,196,201,227
After much fooling arround, I realized that those codes are actually the EBCDIC codes of "JCLEDIT"
Anybody knows how to have GetString do the conversion automatically?
If not, what would be a good algorithm to convert EBCDIC to ASCII?