IBM Mainframe Forum

Hello All,

I am new and don't have knowledge on mainframe macros.

Could you please help me with Macro for copying the number/identifier from mainframe emulator hummingbird to Excel and then reject the request and then open another request and perform the same action copy from mainframe and paste into Excel and so on till the last row/request is reached. The number of rows/request is not known we can limit it to any number if the fixed number of rows are needed. The number/identifier length to copy after opening the request is would be 9 bytes.

I am new and don't have knowledge on mainframe macros.

irrelevant ...
You will need to learn about <hummingbird> macros

and ...
hummingbird is NOT a mainframe emulator , it is a 3270 terminal emulator

Thanks much for your reply. Could you please help me with the macro code or point me in right direction

Thanks again

look at the hummingbird manuals

Alternatively, FTP (or whatever) the data set (not a file) to the machine where the Excel is running(the data will now be in a file) and load the file to Excel.

NicC's solution is the most generically viable solution, but it is quite difficult to create XLS or XLSX data on a mainframe. The usual method is to create text type CSV data on the mainframe and send it to the workstation. This is not necessarily the most ideal solution, as CSV can't do some of the fancy formatting some of the spreadsheet programs like Excel can do, but at least the data can be sent.

Rather to my surprise I discovered CSV data can contain spreadsheet formulas for at least some spreadsheets. OpenOffice / Libreoffice as well as Excel will take formulas.

from the wording it looks like the TS wants to script some 3270 screen sequence