| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| code to extract data from a website runs of XP but not Vista | Excel Programming | |||
| Code runs slooooww | Excel Programming | |||
| Code only runs once | Excel Programming | |||
| Code runs in 2002 but not in 97!? | Excel Programming | |||
| can navigate through intranet site with Web Query (VB code?)? | Excel Programming | |||
Linear Mode
