You can use the OnTime method to call a procedure, and that procedure
can then call Refresh on the query tables. See
http://www.cpearson.com/excel/OnTime.aspx for information and example
code for using OnTime and Windows Timers.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Thu, 23 Oct 2008 17:55:27 +0100, "teepee"
wrote:


"Don Guillett" wrote

You must have a REALLY fast connection.

I do. What I need is some VBA that will issue the 'Refresh all' command
every second.