Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date/Time
Is it possible to run a macro every month at a particular time? Such as at
noon on the 5th of every month. How would I go about doing this? Thank You, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date/Time
modify to suit.
Private Sub Workbook_Open() If Date DateSerial(2004, 11, 30) Then MsgBox "hi" End If End Sub -- Don Guillett SalesAid Software "tjh" wrote in message ... Is it possible to run a macro every month at a particular time? Such as at noon on the 5th of every month. How would I go about doing this? Thank You, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date/Time
I believe you still have to open the workbook with this situation. Is it
possible to get the macro to open the file/workbook and run the macro by itself? Even if the computer is turned off and run it in the background -- then when the computer is logged onto the file shows up. I think this is doubtful but thought I'd ask. "Don Guillett" wrote: modify to suit. Private Sub Workbook_Open() If Date DateSerial(2004, 11, 30) Then MsgBox "hi" End If End Sub -- Don Guillett SalesAid Software "tjh" wrote in message ... Is it possible to run a macro every month at a particular time? Such as at noon on the 5th of every month. How would I go about doing this? Thank You, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting text format of time/date into Excel time/date for subtr | Excel Worksheet Functions | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) |