Running a Macro Automatically
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 |
Running a Macro Automatically
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 |
All times are GMT +1. The time now is 12:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com