Sleeper: Screen scraping

[philfer]

Hello,

We are using a new application at work that is a web based app that uses pop up windows to list transactional data

The problem is that you cant copy and paste that data into excel so if I want to do any real analysis I have to type it all out again!!!

With no help from the vendor and the amount of hair I have left to pull out is there any way I can use VBA to scrape a screen

I assume I cant use a web query as the pop up page doesnt have a URL

I can see the window name in task manager so should be able to get Excel to "see" it but if anyone has any idea as to how I can progress (or whether a different language would be better i.e. C#) then please let me know as I would like to retain some hair for a combover scenario!!!!

Many thanks

[Aussiebear]

Have a look here and see if you can go the next step

http://stackoverflow.com/questions/11917428/excel-2010-vba-code-to-copy-screen-to-clipboard
http://stackoverflow.com/questions/9022245/get-text-from-clipboard-using-gettext-avoid-error-on-empty-clipboard

[philfer]

Hi,

Thanks for your reply.

Rather than have a creen shot I need to scrape/read the actual values from the screen so that I can do analyses on the number

Many thanks