philfer
04-04-2013, 02:38 AM
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
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