Hi, <p>In general, I am looking for a simple and inexpensive screen scrapping <BR>
utility. More specifically, I am looking for a utility that would produce a <BR>
pop-up window once I key a specific character in a specific area of my screen <BR>
(w/ 5250 emulation); this pop-up window should allow you to enter data into a <BR>
spreadsheet or document using Excel, Word, Access or whatever. I just need to <BR>
&nbsp;capture the data (possibly encrypted) in ASCII format on a local drive to be <BR>
emailed or in a secure network drive (NOVELL NetWare). We do not have Office <BR>
Vision. I think I may be able to do this with a PC package. If anyone has <BR>
done something similar and/or has any suggestions, please advise. Thank you. <p>Sincerely, <BR>
Diana D. Virgei

Most screen scraping utilities that I know of scrap while play a macro that is <BR>
navigating though many screens. It sound like you are looking for a utility <BR>
that watches over a 5250 emulation session for a given screen. Then once that <BR>
screen shows up, invoke a MS application(Word, Execle etc..) If that is what <BR>
you are saying I have not heard of such a product. Is that what you are <BR>
asking?

Diana, <p>Is the end result that you want to send an encrypted email based on some AS/400 <BR>
&nbsp;information? Your AS/400 can send email. How important is the encryption? You <BR>
&nbsp;can place a proxy mail server between your AS/400/other mail server that <BR>
encrypts/decrypts messages. I have been experimenting with this concept at <BR>
home for a few weeks and it appears to work for the minimal volume that I <BR>
generate on my AS/400. <p>David Morris

I've only seen one screen scraping application so far, which was during a brief <BR>
demo. Now that you mention it, I do believe it involved a macro. Anyway, let <BR>
me tell you more specifically what I am trying to accomplish. We have a <BR>
purchased AS/400 Order Entry application we were about to customize to allow <BR>
the users to enter credit card data when a customer requested paying via Master <BR>
Card, Visa, etc. Right now, the application allows you to establish and use <BR>
different "payment type codes"; hence, we could set up a payment type code <BR>
specifically for credit card orders. I was hoping a screen scrapping utility <BR>
&nbsp;could invoke a pop-up window for entering CC data once this payment type code <BR>
&nbsp;is spotted on the screen. The data doesn't have to be in any Microsoft Office <BR>
format, just in some format to store it and/or pass it on to the billing <BR>
department via email or a shared directory. I'm trying to keep this data <BR>
secure and also attempting to keep keystrokes to a minimum. Another approach <BR>
would be to have the O <BR>
E user invoke a macro that would automatically fill in the correct payment code <BR>
on the screen and then allow her to enter CC data in some sort of ASCII <BR>
format. What do you think?

Thank you for your quick response. The data I'm trying to capture and <BR>
automatically email involves credit card info. so it does have to be secure.