Pop up html page

[me_king]

Hello everyone,
I am working on a website automation and I'm facing a real problem there. The web-site is Consumer Prices (MEI) : Consumer prices - Annual inflation and I am able to navigate the page. There is a drop down which has options of downloading the data from the site in various formats. There when you select an option a modal dialog pops up where in we have to click "Export to Excel". The problem I am facing is I cannot access the DOM object of the pop window. I have tried various methods like

[I]Public[/I] WithEvents [I]IE1 As InternetExplorer 
Public[/I] IE2 As [I]InternetExplorer[/I]

also I have tried the api to get the hold of the pop window but failed.

 

[me_king]

Hello everyone,
I am working on a website automation and I'm facing a real problem there. The web-site is Consumer Prices (MEI) : Consumer prices - Annual inflation and I am able to navigate the page. There is a drop down which has options of downloading the data from the site in various formats. There when you select an option a modal dialog pops up where in we have to click "Export to Excel". The problem I am facing is I cannot access the DOM object of the pop window. I have tried various methods like

[I]Public[/I] WithEvents [I]IE1 As InternetExplorer 
Public[/I] IE2 As [I]InternetExplorer[/I]

also I have tried the api to get the hold of the pop window but failed.

Got the solution finally. Thank you

<code>
Set myhtmlframe = ie1.document.frames(1).document myhtmlframe.getElementById("btnExportToExcel").Click</code>

I was trying to load frames DOM before the new frame loads and so I thought it was not a frame but a modal window.