Issue with WebBrowser1.Navigate

[KiaOrana]

Hi,

I am having an issue with embeddable map from Google fusion and excel 2010.

Until now, I could easily embed a map into excel 2007 using this code:

Private Sub Workbook_Open()
Sheet1.WebBrowser1.Navigate "https://www.google.com/fusiontables/embedviz?viz=MAP&q=select+col2+from+3489788+&h=false&lat=-27.97507552989698&lng=153.36298599999998&z=9&t=1&l=col2"
End Sub

However, my company upgraded to Office 2010 and I now face an issue that I can't explain. When the workbook loads, I get a script error saying:

The script error says:

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

I have created a test file that you can find here:

http://dl.dropbox.com/u/8843455/test_file.xlsm


What's interesting, is that if I change the code to direct me to Google's main page it will work:

Private Sub Workbook_Open()
Sheet1.WebBrowser1.Navigate "https://www.google.com/"
End Sub

It's only when I replace the URL with the Embeddable link that it stops working!!

https://www.google.com/fusiontables/embedviz?viz=MAP&q=select+col2+from+3489788+&h=false&lat=-27.97507552989698&lng=153.36298599999998&z=9&t=1&l=col2


Please, I really need some help here!!

Thanks a lot guys,

Mike

 

[JWahlin]

Hi,
Noticed this is an old thread but I am trying to embed a webpage into my excel sheet but with the above code

Private Sub Workbook_Open()
Sheet1.WebBrowser1.Navigate "https://www.google.com/"
End Sub

i cant get it to work. I get the following error "Compile error: Method or Data member not found". Im using excel 2010 on windows 7.