Need help for macro which capture mainframe data to excel sheet

[satishkumar]

Hi All -

Could you all please help me to create a VBA Excel Macro.I need a macro which should capture data from Mainframe screen to Excel sheet.

I have four header in excel sheet as EDATA, MDATA, ODATA,LDATA in which I need data for each ssn from their particular location given on attached Mainframe screen shot. In addition to that two command button on sheet as Start to run the macro and Clear to delete data in excel sheet. I have a column dedicated for SSN which may contain more than one – for example I have given 30 ssn in attached excel sheet.

Before starting this request, We need SDATA at 02,06 location in mainframe and <tab> to move at 02, 15 location where we find S. We need to provide ssn next to S and those ssn will get from Excel sheet. As soon as we we find ssn next to s then <enter>.After that We will get all screen 2,3,4,5 which are mainframe screenshots and those data need to capture in Excel sheet.

Please feel free for any additional indormation if required and thanks in advance for support and help.