Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 91
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 26
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
on my screen lower left, it says calculate - to the right of "read sharilynn Excel Discussion (Misc queries) 2 January 16th 07 05:09 PM
copy/paste words in cell can't be read on screen MO Excel Discussion (Misc queries) 2 April 28th 06 03:47 PM
Excel and AS400 DB2 database Esperanza[_2_] Excel Programming 0 December 28th 04 09:06 PM
DDE to Query AS400 DB Joseph[_26_] Excel Programming 0 February 9th 04 10:46 PM
SQL against AS400 R. Choate Excel Programming 4 November 7th 03 09:11 PM


All times are GMT +1. The time now is 04:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"