To get the URL of a pop-up window

[Bhashkar]

Hello my future savior,

Problem is very simple, but i am finding it hard to get around. I want to capture the URL of a pop-up window using VBA. when i click a link, it open a pop-up window, i used the code:

Cells(2, 3).Value = IE.LocationURL

but it is pasting the link of the already opened webpage, but not the pop-up window. Any help will be highly appreciated. thanks!

 

[Chihiro]

Have a look in thread below for one way to do it.

https://chandoo.org/forum/threads/scrapping-data-from-specific-site.39440/page-5

Edit: Woops may have misunderstood your question. Try code in link.
http://www.vba-market.com/ie-vba-working-with-pop-up-window/