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?

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?

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?