| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Every 15 mins
Hi
I have a workbook, in which I have a workbook_open macro. After the initial run I would like the workbook to stay open and the macro to run every 15 mins throughout the day and then close at a specific time, say 19:00. What is the best way to do this. I had thought of a delay at the end of the first run, with the next line being workbook_open.macroname, but I wasn't sure if this was the best method. Thanks for the advice Richard |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Run Every 15 mins
Hi Richard
Check out http://www.cpearson.com/excel/OnTime.aspx -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Richard" wrote in message ... Hi I have a workbook, in which I have a workbook_open macro. After the initial run I would like the workbook to stay open and the macro to run every 15 mins throughout the day and then close at a specific time, say 19:00. What is the best way to do this. I had thought of a delay at the end of the first run, with the next line being workbook_open.macroname, but I wasn't sure if this was the best method. Thanks for the advice Richard |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Run Every 15 mins
Thanks Ron
"Ron de Bruin" wrote: Hi Richard Check out http://www.cpearson.com/excel/OnTime.aspx -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Richard" wrote in message ... Hi I have a workbook, in which I have a workbook_open macro. After the initial run I would like the workbook to stay open and the macro to run every 15 mins throughout the day and then close at a specific time, say 19:00. What is the best way to do this. I had thought of a delay at the end of the first run, with the next line being workbook_open.macroname, but I wasn't sure if this was the best method. Thanks for the advice Richard |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i convert a value quoted in hrs,mins,secs to just mins | Excel Worksheet Functions | |||
| Please help... only have 20 mins | Excel Worksheet Functions | |||
| Sum of Hours/mins | Excel Worksheet Functions | |||
| Adding minutes showing total in hours/minutes, i.e., 60 mins + 60 mins + 15 mins to total of 2 hours 15 mins? | Excel Discussion (Misc queries) | |||
| How to convert numeric value to mins and addimg mins to Hrs. | Excel Worksheet Functions | |||
Linear Mode
