>The company I work for uses a commercial Lawson Insight database. To the best of my knowlege, there is no way to use "CreateObject" for this database so that I can push/pull data from the applicataion. Therefore, I'm trying to figure out if I can screen scrape the data. I have sucessfully used a program called SendKeys that was published in FoxPro Advisor a few years ago to push key strokes to the apoplication. So, I'm able to get the data to show up on the screen automatically but now I'd like to figure out a way to scrape that data. I've searched the web for this info but can only find information releated to scrapping data from web pages. The application is a client server app - not web based. Does anyone know of an API that can scrap data from a regular desktop windows app?

I'd look real, real hard at the OLEDB connection possibility Naomi brought up before screen scraping. If you need enhanced privileges, ask your IT department if you could Remote Desktop in to a machine that has those privileges (I don't know how your current environment is set up). If you've got a legitimate project, their job is to help you, not be Mordac ( http://en.wikipedia.org/wiki/List_of_minor_characters_in_Dilbert#Mordac )

If you absolutely, positively need to scrape, and you've got SendKeys working with it, maybe you could get SendKeys to tab to the fields of interest, then Ctrl-C to copy, Alt-Tab to the program where you're dumping the data, then Ctrl-V to paste. Of course, that's not going to help with screen info that's not a tab stop (in VFP terms, for example a label rather than a text box).