Help with WebBrowser control

[KiaOrana]

Hi guys,

I have an issue with a WebBrowser control. I have a WebBrowser form in my workbook which worked really well until I got upgraded from Excel 07 to Excel 10 and from win xp to win7.

Now, instead of displaying the website, I got an error "This program cannot display the webpage" as if Excel does not have acess to the net anymore. I checked my firewall and created an exception rule for excel but it does not seem to be the issue as it still does not work.


I use the basic code

Private Sub Worksheet_Activate()

WebBrowser1.Navigate2 "http://www.google.com"

End Sub

I created a file with just the WebBrowser form so you can have a look to see if it works on your system or if it comes to an issue with the code.

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

I really need help with this, any input will be much appreciated!

Thanks a lot

 

[bstory84]

I downloaded your document and it does work if you select another sheet and then go back to sheet1.

I think the issue is that if macros are disabled when you open the workbook sheet1 is already activated thus skipping the actual event.

When you enable the macros you have to initialize the sheet again.

Just my experiance with it.

 

[KiaOrana]

That's crazy! It does indeed work when changing sheet!

Thanks a lot for pointing that.

It's really annoying tho, because the form is meant to sit in a dashboard used by my management and I don't want them to have to fiddle with the sheets in order to see the page display properly. I wonder if there's anything I can do to make it work directly.

Anyway, thanks a lot mate!

 

[bstory84]

Sorry i think my thought process is wrong.

Either way your better off putting this in the workbook open event.
will work everytime.

Private Sub Workbook_Open()
Sheet1.WebBrowser1.Navigate2 "[URL]http://www.microsoft.com[/URL]"
End Sub

 

[KiaOrana]

Thanks a lot for your help.

I'll be honest with you, I'm struggling a bit with VBA, I'm learning on the go. If I send you a link in PM, do you think you could have a look at something I've done?

I send you a PM.