How to scrap data from POP up IE?

[Ratan Bhushan]

Hi Team

I am making a macro which scrapes the data from IE.

Where I have stucked is when I am clicking on "Print Summary" on IE, a new pop up IE turns up, I am unable to make an object for that pop up, so I am unable to scrape any data from that IE.

Please help.

Thanks
Ratan

 

[Marc L]

Hi !

In case it is not a « pop up IE » but just a page update after an action
(like a click on a button for example), just wait until new page is ready :

While IE.Document.readyState <> "complete": Wend …

As you must see, the object is still the same !
And as IE.ReadyState is usefull only for the initial load of IE …
​