Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
time generated code
Is it possible to, at the same time every day, open a workbook or recalc it
if it's already open, perform some test on a date field and if the condition is true, generate a popup or msgbox? Can you make the message box appear on top of all windows? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
time generated code
Yeah, using OnTime. See http://www.cpearson.com/excel/ontime.htm
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Steve" wrote in message ... Is it possible to, at the same time every day, open a workbook or recalc it if it's already open, perform some test on a date field and if the condition is true, generate a popup or msgbox? Can you make the message box appear on top of all windows? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
time generated code
Check out the OnTime method in the VBA helpfile.
Here's a great overview from Chip Pearson: Scheduling Events With OnTime And Windows Timers Hope that helps, Roger "Steve" wrote: Is it possible to, at the same time every day, open a workbook or recalc it if it's already open, perform some test on a date field and if the condition is true, generate a popup or msgbox? Can you make the message box appear on top of all windows? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Video Time Code | Excel Discussion (Misc queries) | |||
Time Code in Cell format ? | Excel Discussion (Misc queries) | |||
Code for entering time - trying again | Excel Discussion (Misc queries) | |||
Code for entering time | Excel Discussion (Misc queries) | |||
Custom dat & time code | Excel Discussion (Misc queries) |