Scraping field values on any screen on desktop

[Zinc]

scenario:
Some program launched thru IE8. May not be a web page or maybe it is.
Has a ticket field I want to get the number from.
I then use a 2007 accdb to build information for ticket and need to write the info back to the appropriate fields on that company form.

What's needed.
Code to identify which window on the desktop I am interested in.
Code to find the field with the ticket number once correct screen is identified.
Code to paste data back to that screen.

Assumptions.
Future launches of this company pgm will have consistent identifiers and may not have to be found/identified after the first identification. Maybe it will have to be done each time it is relaunched, don't know.

Q. Can this even be done with VBA?
Q. If so, is there an example in an accdb?

Yes I am asking for a fully functioning code example, I find dissecting an example much more useful than just some code written out that assumes I know exactly where it is to be put and how it should link with objects like buttons etc.

I'm just not that good! But I can do a very good job of plagiarizing functional code. Sometimes I can even fix non-working code.

 

[Rx_]

From the zero response so far, the answer to your general question is probably no.

Now: your field tickets
Are they in XML, PDF, or some other format that might be saved as, then converted?
Here is an example:
http://www.platts.com/IM.Platts.Content/ProductsServices/Products/gasdaily.pdf
Select the table of prices by dragging your mouse over and selecting the data. Then Paste it into Excel.
Now, imagine doing some fancy parcing and some word matching. Then migrating this into SQL Server (or your favorite Database).
OMG! that program would replace a $4,000 a month subscription. Disclaimer: I would never ever do that in real-life, this is just a mythical what-if situation. You know, just like we talk about urban myths like bigfoot, UFO's and Montana.

My suggestion is to evaluate and break down your on-line field ticket source and see if you can come up with a series of steps to ask questions.

 

[Zinc]

I recently discovered that the content is indeed html.
Will look into it more since there seems to be plenty when it is html.