ExcelBanter - how do i autorefresh a datasource every 5 seconds in Excel?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - how do i autorefresh a datasource every 5 seconds in Excel? (https://www.excelbanter.com/excel-programming/338132-how-do-i-autorefresh-datasource-every-5-seconds-excel.html)

HUGO

how do i autorefresh a datasource every 5 seconds in Excel?

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....

Tim Williams

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....

All times are GMT +1. The time now is 12:43 AM.