ie9 VBA to refresh browser issue

[dantheman9]

hi im trying to automate a refresh process from excel for an ie9 browser.
but i get a client disconeected error when the code gets to the refresh command...relevent bits below;

Public Browser As Object
 
Sub start()
Dim WebPageDirectory As String
WebPageDirectory = Environ("appdata") & "\Race Creator\Temp.htm"
OpenBrowser WebPageDirectory
Timerun = Now() + TimeValue("00:00:20")
Application.OnTime Timerun, "refreash"
 
End Sub
 
Function OpenBrowser(tmpURL)
Set browser = CreateObject("InternetExplorer.Application")
If browser.Addressbar = True Then
browser.Addressbar = False
End If
If browser.StatusBar = True Then
browser.StatusBar = False
End If
If browser.Toolbar = True Then
Browser.Toolbar = False
End If
If browser.MenuBar = True Then
browser.MenuBar = False
End If
browser.Resizable = True
browser.Visible = True
browser.Navigate (tmpURL)
End Function
 
Sub refreash()
 
With Browser
.refresh
End With
 
End Sub

 

[dantheman9]

thanks Norie,

I think i don't quite understand what needs a watch adding?

I have set one for the Public Browser Object - that returns no values.

then on XP with ie 8 it returns a value of windows internet explorer.

is that what you mean?

 

[Norie]

There is only one object variable for the browser - Browser.

By the way it still isn't clear where the code is located.

It should not be in the ThisWorkbook module.

 

[dantheman9]

right so it works ok when the create object is used in the function section;
expression: browser
Value: "Windows Internet Explorer"
Type: Object/IWebBrowser2
Context: Module 1

then after the end of the function all values for Browser are reset to nothing, so i need to add something in the fuction to make sure it gets passed to the Public location?

 

[Norie]

So have you moved all code, including any declarations outside the ThisWorkbook module?

 

[dantheman9]

yes it's all sitting in module1

 

[Norie]

Well I don't know what the problem is.

It could be something to do with the browser, perhaps not the version but the settings.

Why are you refreshing the page anyway, it is only a text file?

 

[dantheman9]

ok, i'll have to look and see if ie9 might be blocking it somehow.
the text file is updated with new information at set intervals, so i just needed a way to automate the refresh for a remote screen.

strangley enough, this all works fine on WinXP running ie8, just seems to not be playing on ie9/win7.

thanks for your time with it