Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
on my screen lower left, it says calculate - to the right of "read | Excel Discussion (Misc queries) | |||
copy/paste words in cell can't be read on screen | Excel Discussion (Misc queries) | |||
Excel and AS400 DB2 database | Excel Programming | |||
DDE to Query AS400 DB | Excel Programming | |||
SQL against AS400 | Excel Programming |