Date/Time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
modify to suit.

Private Sub Workbook_Open()
If Date > DateSerial(2004, 11, 30) Then
MsgBox "hi"
End If
End Sub


--
Don Guillett
SalesAid Software
(e-mail address removed)
tjh said:
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
Click to expand...
You,
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook Outlook time-based rules 0
Sum work hours to hours & nearest 10th of an hour 14
Macro triggered by date 4
Macro with a memory 1
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
NEWBIE needs BIG help with Macro 1
Run report on the 5th of every month automatically 0
import access dates into xl "calendar" 2

Back
Top