I don't see a solution if you want to run items periodically with an
interval greater than a day, but for shorter intervals, look at the
Application.Ontime function

See Chip Pearson's example
http://www.cpearson.com/excel/ontime.htm

The workbook will need to remain open.
--
Regards,
Tom Ogilvy

"as_sass" wrote in
message ...

Hi!

I have searched this forum a number of times for a definite answer on
how to time macro execution, but have not found anything that helped.

Problem I have:

Run macro either at certain time(s) of day or in certain time interval
(whichever is easier).

Preferably using really easy code in which I understand what to
substitute to change the time interval, as I'm not too familiar with
the whole VBA thing.

Anybody got any (simple) ideas?

Thanks!

sass


--
as_sass
------------------------------------------------------------------------
as_sass's Profile:
http://www.excelforum.com/member.php...fo&userid=9065
View this thread: http://www.excelforum.com/showthread...hreadid=477036