You can use the OnTime method of the Application object in VBA to
run a macro at a specified interval. See
www.cpearson.com/excel/ontime.htm for more details.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Pat" wrote in message
oups.com...
Hi everyone,
I'm running a web query from an Excel 97 file, the data on the
web site
change about every 10 mn.I'd like to use a macro to refresh my
query
every 10 mn or so as well.I've got all I need in my VBA code
except for
this aspect.
So my question is either :How to refresh a web query every x
mn? or
How to run a macro every x minutes ?
I'd appreciate any help you could give me.
Thanx.