| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with time interval | Excel Worksheet Functions | |||
| x-axis time interval | Charts and Charting in Excel | |||
| Repeat a formula with interval | Excel Worksheet Functions | |||
| Repeat a formula with interval | Excel Worksheet Functions | |||
| time interval calculation | New Users to Excel | |||
Linear Mode
