Hi again

A couple of weeks ago I asked if there was a command to refresh a web page
on a local drive

As I gave very little detail I don't think that anybody understood my
request :(
I will now try to clarify
Using Excel 2002 on Vista

Purpose:
The program puts certain details on a sheet which is published as a local
web page and, using Extended Desk-top, is projected onto a large screen
The detail on the sheet is frequently updated and the wish is for the
projected page to update (refresh) automatically. Currently the user has to
go to the page and press F5

I will describe the full set of relevant code

'I have a function to launch a web page using IE:

Public Browser As Object

Function OpenBrowser(tmpURL)
Set Browser = CreateObject("InternetExplorer.Application")
Browser.Navigate (tmpURL)
Browser.Addressbar = False
Browser.StatusBar = False
Browser.Toolbar = False
Browser.MenuBar = False
Browser.Visible = True
Browser.Resizable = True
End Function

'I then start the program opening IE with the specified web page :

Dim WebPageDirectory As String
WebPageDirectory = Range("My_Directory") & "\page.htm"
'Using the function called OpenBrowser
OpenBrowser WebPageDirectory

'In another routine on a form these lines redraw the page

MyAdd = Range(Cells(1, 1), Cells(NumberTablesRows + 1, NumberTablesColumns +
1)).Address
With ActiveWorkbook.PublishObjects.Add(SourceType:=xlSo urceRange,
Filename:=Range("My_Directory") & "\page.htm", Sheet:="Venue",
Source:=MyAdd, HtmlType:=xlHtmlStatic)
.Publish (True)
.AutoRepublish = True
End With
Up to here it all works well

At this point I need Excel to refresh the Page.htm with a command using
something like (one of) the following :
With Browser
.Republish
.Publish
.Refresh
End With
Unfortunately all of the above commands give me error 91 - "Object variable
or With Block variable not set"

I wondered whether there is a command that will refresh (F5) the web page?

Thanks in advance
--
Regards,
Peter Bircher

Cell : 083 233 1628
Email: