Thread: code to navigate IE7 runs on XP but not on Vista
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ak Man Ak Man is offline
external usenet poster
  
Posts: 9
Default 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?
Reply With QuoteReply With Quote