IE7 launched via VBA won't load pages from google

[tomsoyer]

Hi,

I am trying to launch IE7 and load pages at google.com via VBA (VB6.3). While the following code can launch IE7 and load yahoo pages:

Sub test()
Dim objIE As InternetExplorer
Set objIE = New InternetExplorer
objIE.Visible = True
objIE.Navigate "http://www.yahoo.com"
End Sub

It doesn't work for any of the pages at www.google.com, i.e., IE7 hangs and won't load pages from google.com. This happens only if IE7 is launched via VBA. In addition, if one uses the above code to launch IE7 and then physically type www.google.com in the navigation bar, IE7 would just hang and won't load the google home page.

Does anyone know if this is a known issue. If so, is there a work around or fix? If not, then is this a bug?

Thanks,

Tom

 

[pgc01]

Hi
Welcome to the board

If you are working with IE 7, don't forget that it works by default in protected mode. Please confirm that you either:

- run IE in non-protected mode (I don't recommend it)
- you have added the site you are trying access to your list of trusted sites

You may have to close IE and restart it for the options to apply.

 

[tomsoyer]

Hi,

Thanks! IE7 was running in non-protected mode but google.com was not on the trusted site list. After I added it to the list, then the code worked. However, yahoo.com was not on the trusted site list either and it worked just fine. Is this normal behavior?

Also, is it possible to auto detect, via VBA, whether (a) google.com is on IE7's trusted site list, and (b) it's running non-protected mode?

Thanks very mcuh.

Tom