Running a Macro Automatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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?
 
Back
Top