I am running a script that does an automatic login for 100's of training
ID's. We have the script that opens the browser (uses followhyperlink) and
enters the user name and password using sendkeys. What I need to know how to
do is determine when the window has correctly opened and when it hasn't.
When it is correct, it goes to a very specific URL. Ideally, I would check
the URL after our Wait statement and determine if the URL is the correct one
and annotate on the spreadsheet error or complete. In either case, I need to
close the IE window after the check because the VBA blows up after 50 IE
windows. Right now I am using Excel 2003.

To Clarify:
How do I get the address of an open IE window using VBA?
How do I close an open IE window using VBA?