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,

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,

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,