Page 1 of 1

Copying from Emulator Hummingbird to Excel

PostPosted: Tue Nov 14, 2017 1:31 pm
by Najamuddin
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.

Re: Copying from Emulator Hummingbird to Excel

PostPosted: Tue Nov 14, 2017 1:45 pm
by enrico-sorichetti
I am new and don't have knowledge on mainframe macros.

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

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

Re: Copying from Emulator Hummingbird to Excel

PostPosted: Tue Nov 14, 2017 2:16 pm
by Najamuddin
Thanks much for your reply. Could you please help me with the macro code or point me in right direction

Thanks again

Re: Copying from Emulator Hummingbird to Excel

PostPosted: Tue Nov 14, 2017 2:26 pm
by enrico-sorichetti
look at the hummingbird manuals

Re: Copying from Emulator Hummingbird to Excel

PostPosted: Tue Nov 14, 2017 4:28 pm
by NicC
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.

Re: Copying from Emulator Hummingbird to Excel

PostPosted: Tue Nov 14, 2017 5:24 pm
by steve-myers
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.

Re: Copying from Emulator Hummingbird to Excel

PostPosted: Tue Nov 14, 2017 5:32 pm
by enrico-sorichetti
from the wording it looks like the TS wants to script some 3270 screen sequence