View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kryer Kryer is offline
external usenet poster
 
Posts: 22
Default Save excel as web page and have htm file update automatically

I am trying to save an excel worksheet that querys data every 5 minutes. I
would like to convert the worksheet into an htm file and publish to the
network and I have the option set for republish file upon save. However, what
I am looking to do is have the htm file when open update the screen
automatically every 5 minutes instead of the user having to do either a
close/open of the file or hit the refresh button of the htm page. Can this be
done?