Fire A Macro Once A Day

G

George Lee

How do you add a timer to a macro script that would fire, say, once a day to
run a macro. There would be no userform associated with the scripts.
 
J

Jay Freedman

George said:
How do you add a timer to a macro script that would fire, say, once a
day to run a macro. There would be no userform associated with the
scripts.
Click to expand...

Use the OnTime method in an AutoExec macro, and specify the time and the
name of the macro to run at that time.

Of course, if the user doesn't start Word that day, nothing at all will
happen.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
K

Karl E. Peterson

George Lee said:
How do you add a timer to a macro script that would fire, say, once a day to
run a macro. There would be no userform associated with the scripts.
Click to expand...

I think I'd *strongly* consider using the Task Scheduler.
 
K

Karl E. Peterson

Jay Freedman said:
Right! I've also seen a cartoon of lost souls being tortured in Hades, and
one demon tells the other, "They didn't check Google first!" :)
Click to expand...

Hehhehheh...
 

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

VBA word change keys 0
Need Help with Macro Security 1
Re-title multiple MS Project .mpp files at once 0
Macro warning in word 1
Want to have macro execute automatically when doc created 3
Word VBA - Want to test if Full Name is NOT Present in document 0
Firing Event in another user form 1
How can the font and size of (all) citation numbers be altered? 1

Top