code to navigate IE7 runs on XP but not on Vista
 

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?

code to navigate IE7 runs on XP but not on Vista
 

try this

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

--
Ak


"Ed Vogel" wrote:

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?

code to navigate IE7 runs on XP but not on Vista
 

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?

"Ak Man" wrote:

try this

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

--
Ak


"Ed Vogel" wrote:

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?