code to navigate IE7 runs on XP but not on Vista

[Ed Vogel]

My macro code:
Set ie = CreateObject("InternetExplorer.Application")
ie.Navigate "http://www.anything.com"
ie.Visible = True
Do While ie.busy And Not ie.ReadyState = 4
DoEvents
Loop
ret = ie.Document.Title '=> error: method Document of IWebBrowser2 failed

There is something to do with IE7 Protected mode security on Vista. Can
anyone help me to work around this issue?

 

[Ak Man]

try this

ActiveWorkbook.FollowHyperlink Address:="http://www.anything.com/", _
NewWindow:=True

 

[Ed Vogel]

1. Is this code going to work with IE7 Protected mode on Vista?

2. If positive, how do I extract data from the browser page after IE window
is open?