Refering to Internet Explorer Document when it is already open in Excel VBA

[mathsbeauty]

In Excel VBA, how may I refer to already open page in Microsoft Internet Explorer?Something likeInternetExplorer.Application.Document.forms(1)I don't want to set application and navigate to specific website (automation of Internet Explorer from Excel VBA). The web page is already open in internet explorer. Creation of Internet Application and navigation to same website is impossible as it needs logins and form is displayed after navigating many other pages.

 

[Rijnsent]

Hi Mathsbeauty,
this post might help: http://www.mrexcel.com/forum/excel-...pplications-macro-already-open-ie-window.html
The next bit of code would be to check if the open window is indeed the one pointing to the URL you want to get the info from.
Cheers,
Koen