How can I automatically run a macro every 1 minute or every 5 minuts

[Lawrence M. Seldin, CMC, CPC]

I have Excel 2000

I have a macro that calculates from a real time data feed.
How can I have it run every 1 minute or every 5 minutes on its own.

Also, how can I stop it.

Thanks much,


Lawrence M. Seldin, CMC, CPC
Author of POWER TIPS FOR THE APPLE NEWTON and INTRODUCTION TO CSP
Author of RECRUITSOURCE PEOPLESOFT EXAM and RECRUITSOURCE SAP/R3 EXAM


NOTE: To send me an email, remove TAKEOUT from my email address: (e-mail address removed)

NOTE: My web home page: www.seldin.net

 

[Frank Kabel]

Hi
have a look at the OnTime method. See:
http://www.cpearson.com/excel/ontime.htm

 

[Lawrence M. Seldin, CMC, CPC]

Frank,

Thanks for the info.

- Larry



--------------------------------------------------------

Hi
have a look at the OnTime method. See:
http://www.cpearson.com/excel/ontime.htm

Lawrence M. Seldin, CMC, CPC
Author of POWER TIPS FOR THE APPLE NEWTON and INTRODUCTION TO CSP
Author of RECRUITSOURCE PEOPLESOFT EXAM and RECRUITSOURCE SAP/R3 EXAM


NOTE: To send me an email, remove TAKEOUT from my email address: (e-mail address removed)

NOTE: My web home page: www.seldin.net