Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using application.ontime
Got this code in the workbook module...
Had it working one moment, but now its not. Want it to open at specific time, run the macro, and then close. (A)Anyone know the criteria surrounding "application.ontime" Does Excel have to be open? Does the workbook have to be open? (B) How do I effectively run the following code? Private Sub Workbook_Open() Application.OnTime TimeValue("13:38:00"), "Macro1" ActiveWorkbook.Close SaveChanges:=True End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using application.ontime
See www.cpearson.com/Excel/OnTime.aspx
-- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "J.W. Aldridge" wrote in message ups.com... Got this code in the workbook module... Had it working one moment, but now its not. Want it to open at specific time, run the macro, and then close. (A)Anyone know the criteria surrounding "application.ontime" Does Excel have to be open? Does the workbook have to be open? (B) How do I effectively run the following code? Private Sub Workbook_Open() Application.OnTime TimeValue("13:38:00"), "Macro1" ActiveWorkbook.Close SaveChanges:=True End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cancelling Application.OnTime | Excel Programming | |||
Help with Application.OnTime | Excel Programming | |||
application.ontime | Excel Programming | |||
OnTime Unusual Application | Excel Programming | |||
Application.OnTIme | Excel Programming |