Schedule a macro

  • Thread starter Thread starter ewan7279
  • Start date Start date
E

ewan7279

Hi all,

I would like to schedule a macro to run at 22 minutes and 52 minutes past
the hour, so that the latest information available to the spreadsheet is
updated asap (usually available by 21 mins and 51 mins past the hour) to
remove the problem of the user forgetting to do so manually.

The macro is currently a Private Sub updated by the user 'as and when' by
clicking an embedded button on a worksheet, so I would like the solution to
recognise if the user is trying to update before the next info becomes
available (to avoid duplicating info unnecessarily). (In some cases, there
may be a need for the user to update additionally outside of these
parameters, so the button will have to remain).

If possible, I would prefer not to have this in a separate incidence of
Excel...

Any ideas please??

Thanks,
Ewan.
 
If you are running Office 2000-2003, you could schedule a task
reminder in Outlook, then set up an event to monitor the reminder.
When the reminder fires, the event could instantiate Excel and run the
macro unattended.

I have some sample code here you can adapt:

http://codeforexcelandoutlook.com/outlook.html

Scroll down to "Automate Outlook"

HTH,
JP
 
Back
Top