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

  • Thread starter Thread starter Lawrence M. Seldin, CMC, CPC
  • Start date Start date
L

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,

Thanks for the info.

- Larry



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

Frank Kabel said:
Hi
have a look at the OnTime method. See:
http://www.cpearson.com/excel/ontime.htm
Click to expand...

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
 
Back
Top