For automating a manual task, I am trying to send data from excel sheet to mainframe application using VBA code. I am able to connect and communicate using following code,
Set MFscreen = GetObject("", "EXTRA.System").ActiveSession.Screen
I am populating required string on mainframe screen using following code (which is working fine),
MFscreen.area(4, 9, 4, 10).Value = "ABCD"
At an instance, I need to enter a value on mainframe screen in front of a particular string (say XYZ). For it, I would need the location of that particular string (XYZ) on mainframe screen. I am able to check that the required string (XYZ) is present on mainframe screen using below code,
Although i am not able to check its (XYZ) mainframe screen position. Can anybody help in this regards?
I had been using "GetObject("", "EXTRA.System").ActiveSession.Screen" for all my macros and is working fine to connect Excel to Mainframe. I wanted to know if there is some keyword or a simple way to check string location on mainframe screen.
To showcase the scenario, say I have following screen,
TESTMENU COMPANY 09/27/13 11:51:42 0001
ABCDEFG TEST SCREEN SYSTEM VERSION: 000
As shown above, I want to know the location of 'YYY' on the mainframe screen and write 'S' in front of it and 'ABC' after the string. I am facing problem checking the location of string 'YYY' which is (07/07) in above example. Let me know if I had missed any information useful to analyze the issue.