I think this is the sort of thing you mean:
Code:
Sub Test()
Dim SW As SHDocVw.ShellWindows
Dim IE As SHDocVw.InternetExplorer
Set SW = New ShellWindows
' Loop through all the shell windows on the desktop
For Each IE In SW
' If its an HTML document = a webpage
If TypeOf IE.Document Is HTMLDocument Then
MsgBox IE.LocationName
End If
Next IE
Set SW = Nothing
End Sub