ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to read text content of AS400 screen (https://www.excelbanter.com/excel-programming/348810-how-read-text-content-as400-screen.html)

abc[_6_]

How to read text content of AS400 screen
 
Dear all,

Is there a way to read all the text content of a dos mode interface
application, like AS400 or dos prompt?
I want to write a macro to read AS400 current menu's content and status,
then do some calculation and make some input by sendkeys funtion
thereafter.

Thanks



Ron Coderre[_5_]

How to read text content of AS400 screen
 
I'm not sure how helpful this is but...
Years ago I needed to do some "screen scraping" of data from an old banking
general ledger system called FCS. As it turned out, that system had a
scripting language called SISL that nobody in the company even knew about.
Using that, I could find input coordinates from the screen, read lines from
text files, and load the input screens. Maybe your application also has some
kind of scripting language.

Good luck

***********
Regards,
Ron

XL2002, WinXP-Pro


"abc" wrote:

Dear all,

Is there a way to read all the text content of a dos mode interface
application, like AS400 or dos prompt?
I want to write a macro to read AS400 current menu's content and status,
then do some calculation and make some input by sendkeys funtion
thereafter.

Thanks




Dominic

How to read text content of AS400 screen
 
abc,

Yes, you can. What is the interface you are using to access the 400?

I use ISeries Access and there are many functions available to read the
current screen, fields, etc.

If using ISeries, check out http://publib.boulder.ibm.com. There is a
reference to the library's you can use within the Emulator via Macro/Script
coding.

Also you can use the help function within the emulator to get language
reference help. If you know what you want to do, write back, and I can try to
get you started.



"abc" wrote:

Dear all,

Is there a way to read all the text content of a dos mode interface
application, like AS400 or dos prompt?
I want to write a macro to read AS400 current menu's content and status,
then do some calculation and make some input by sendkeys funtion
thereafter.

Thanks





All times are GMT +1. The time now is 02:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com