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?

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?

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?