Hi There!
I've added an activeX web browser
to one of my worksheets that navigates to Google Analytics and displays the real-time overview dashboard ie active users on the website. This works fine; however, when I change to another worksheet and back to worksheet 1 the Google Analytics real-time data freezes and doesn't update.
The only workaround I've come up with is to refresh the browser control everytime I return to worksheet 1 using:
However, this is not the most desirable behaviour I want because the whole page takes a few seconds to reload. Is there any code or properties I can use so the content doesn't freeze and doesn't require refresh/reloading.
I've also tried to use a button to hide/show the web browser to see if this has the same effect, unfortunately, it does and the web content freezes on returning to visible.
I'm using Microsoft Excel 2010 and would appreciate any help!
Dan
I've added an activeX web browser
Code:
Sheet1.WebBrowser1The only workaround I've come up with is to refresh the browser control everytime I return to worksheet 1 using:
Code:
Sheet1.WebBrowser1.RefreshHowever, this is not the most desirable behaviour I want because the whole page takes a few seconds to reload. Is there any code or properties I can use so the content doesn't freeze and doesn't require refresh/reloading.
I've also tried to use a button to hide/show the web browser to see if this has the same effect, unfortunately, it does and the web content freezes on returning to visible.
I'm using Microsoft Excel 2010 and would appreciate any help!
Dan