How do I calculate spreadsheet at five minute intervals

M

Mel T ID

I have a spreadsheet that retrieves data from an external source. I need to
recalculate the spreadsheet at a regular interval, in this case 5 minutes.
Anyone know a fairly simple way to do this?
 
C

Chip Pearson

You can use Application.OnTime for schedule a procedure to be executed
at a specific time. See www.cpearson.com/Excel/OnTime.aspx for details
and example code.

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




On Wed, 11 Feb 2009 13:32:01 -0800, Mel T ID <Mel T
 
Top