I am hoping someone can let me know the easiest way to take text from
the mainframe using either excel or access vba...all I need to know is
how to get it to copy off the screen and then paste it probably in a
spreadsheet....

The easiest way is to use an HLLAPI interface.  Most terminal emulators come
with this interface, and it's not really hard to program to it.   That's
especially true if all you want to do is read the text.  It's been years
since I wrote our code but it's dead simple.

Most emulator vendors provide a developer's guide with docs on their
particular version of HLLAPI (they're all just a bit different if you start
reading status line or things like that) along with sample code.

Dan



<Beal***@gmail.com> wrote in message
Show quoteHide quote

I've used Teemtalk in the past. It's a terminal emulator with VBA -- so
you easily use Excel's VBA or VB to write to or read from the terminal,
connect and so forth.

The demo version doesn't include VBA but I wrote to them and they
eventually sent me a demo version with VBA -- and I ended up buying a
couple of licenses.

Beal***@gmail.com wrote:
Show quoteHide quote

Rolling the dice on vb6
SQL Question
problem formatting excel in vb
VB6 writing to text files requires Close to commit
delete tmp files
Collection of Radio buttons Function
VB6 File Handling Without FSO
Find the Topmost window?
vb 6 and odbc
Error to create a package in VB6