Here's a tricky one for you....

I want to create a macro that runs every five minutes throughout the day. It's an external data query that checks the data for changes. Any suggestions?

Thanks,
Kevin

Check out the OnTime method, and see Chip's page at
http://www.cpearson.com/excel/ontime.htm

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"kkelsey" wrote in message
...
Here's a tricky one for you....

I want to create a macro that runs every five minutes throughout the day.
It's an external data query that checks the data for changes. Any
suggestions?

Thanks,
Kevin