Run Macro Every 30 min

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

Guest

I've got a macro that emails the current status of a project. I would like the macro to auto-run every 30 min. How do I do this? Thanks ahead of time

Bob
 
Checkout the OnTime method 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)

Bob Ewers said:
I've got a macro that emails the current status of a project. I would
Click to expand...
like the macro to auto-run every 30 min. How do I do this? Thanks ahead of
time.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Macro If Cell have "x" value 0
Running a Macro periodically between Time A and Time B 7
Run Every 15 mins 2
OnTime Challenge 4
Rounding Time down 4
auto save code for vb in excell 13
Macro from older version into Office 2013 on Windows 8 3
formula for payment, time vs hourly price 2

Back
Top