On Wed, 30 Apr 1997, benedict de guzman wrote:

> Does anyone know the best way of capturing data from an on-line screen
> program (written in COBOL) running through a terminal emulation like
> 'Reflections' or 'Minisoft' connected to a HP3000 Mpe/ix TurboImage
> platform, into Microsoft Excel and vice-versa????...Can I use VB, Java, or
> any other scripting language???
>
Dear Benedict,

How much data do you want to pass into Excel? More than the screen memory
of the Minisoft or less?
I am a beginner in Minisoft, I have not yet found the best way. Try and
choose:

Method A for more data than the screen memory of the Minisoft:
1. Turn on Capture to Disk before the program.
2. Turn off Capture  to Disk after it.
3. Switch to Excel and import capture file.

Method B for less data than the screen memory but more than 25 lines:
1. Run your program.
2. Run PSCREEN from the contributed library.
3. Download the output of the PSCREEN.
4. Read the downloaded file into Excel.

Method C for less data than a screen:
1. Run your program
2. Select manually the important rectangle of the screen.
3. Switch to Excel and insert selection from the clipboard.

Method D for less data than a screen:
1. Write a Minisoft script that runs your program then
2. Executes a SCREENRECT statement.
3. Writes the resulting string into a file.
3. Switches to Excel by SHELL and DDE-@ statements and imports the file.

                                             Frank

  |\   /~ ~~|~~~ Family : NAGY; first name : FERENC; title : Ph. D.
  | \  |    |    Institute of Isotopes of the Hungarian Academy of Sciences
  |  \ |   -+-   HUNGARY-1121 BUDAPEST Konkoly-Thege M. ut 29,(1525 Bp. POB 77)
  |   \|    |    [log in to unmask]  (36-1)-395-9123 Fax: ~395-9002
`-'    '  `-'    Home: H-1214 BUDAPEST Raketa u. 29. I. 3. (36-1)-277-4229.

There are 3 kinds of programming errors:  syntactical, semantical and mystical.
The programmers have to suck up the users just as much as absolutely necessary.