Thread: how do i autorefresh a datasource every 5 seconds in Excel?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
  
Posts: 1,588
Default how do i autorefresh a datasource every 5 seconds in Excel?
Application.OnTime Now + TimeValue("00:00:05"), "my_Procedure"Tim.


"Hugo" wrote in message
...
I have a worksheet in Excel that retrieves data from a sql server
2000
database. How do i get this datasource to refresh every 5 seconds?

Right now i have a refresh in minutes but i need seconds unit....


Reply With QuoteReply With Quote