Help with WebBrowser1.Navigate

[KiaOrana]

Hi guys,

I am having a very annoying problem.

I created a dashboard for my management team. Embedded in the main sheet is a map created with Google Fusion and hosted on google's server.

I created the dashboard with Excel 2007 on a machine running Win Xp

Everything worked perfectly until last week, when I got a new computer with Win7 and Excel 2010.

Now every time I open the dashboard, the web object does not display and instead I got an error saying "Navigation to the webpage was cancelled"

Here is a screenshot of the error I get:

This is the code I am using:

Private Sub Workbook_Open()
Sheet10111.WebBrowser1.Navigate "https://www.google.com/fusiontables/embedviz?viz=MAP&q=select+colX+from+3563385+&h=false&lat=-X7.97170451586557&lng=153.36300120117187&z=11&t=1&l=colX"
End Sub

Sub auto_open()
Application.DisplayFullScreen = True
End Sub

I believe that uit must be some kind of security settigs somewhere that does not allow me to reach the net from MS Office.

I have no idea what's going on!

I hope someone will be able to help me with this.

Thanks a lot in Advance


Mike

 

[KiaOrana]

So I have managed to partially fix the issue. I went into IE and installed a certificate for google.com. Now, I don't get the error Message any more but I now get a script error.

The script error says:

Line:32
Char:3
Error; Expectd identifier, string or number
Code:0
URL:https://www.google.com/fusiontables...818182&lng=153.50443497460935&z=10&t=1&l=col2


Can someone help me with this??

Thanks a lot,

Mike