how to have a module to repeat itself at a certain time interval?
 

hi all,
im quite new to VBA.
i have done this one module to generate email to several recipients
when some process parameter(s) are operating abnormally.

but i dont really know how to get this module to auto repeat itself
after let say an interval of 5 minutes.

kindly help...

thank you.

how to have a module to repeat itself at a certain time interval?
 

Hi
maybe the OnTime method is what you're looking for for running a macro
periodically. chip has some instructions on his site how so set-up such
a macro:
http://www.cpearson.com/excel/ontime.htm

--
Regards
Frank Kabel
Frankfurt, Germany


Radionise wrote:
hi all,
im quite new to VBA.
i have done this one module to generate email to several recipients
when some process parameter(s) are operating abnormally.

but i dont really know how to get this module to auto repeat itself
after let say an interval of 5 minutes.

kindly help...

thank you.

how to have a module to repeat itself at a certain time interval?
 

I have an example on my website

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Radionise" wrote in message
om...
hi all,
im quite new to VBA.
i have done this one module to generate email to several recipients
when some process parameter(s) are operating abnormally.

but i dont really know how to get this module to auto repeat itself
after let say an interval of 5 minutes.

kindly help...

thank you.