Event

  • Thread starter Thread starter tammy zembower
  • Start date Start date
T

tammy zembower

I have recorded a macro that I need to automatically run at 6:45am daily.
How do I specify this in the code?
 
Everything you need to know about OnTime procedures (but were afraid to ask):

http://www.cpearson.com/excel/ontime.htm

You'll need to have excel running for this to work.

=====
Some versions of windows have scheduler programs. (Or you can get a
freeware/shareware version on the web (www.shareware.com is where I look first.)

Then you could have that scheduling program start an excel workbook. If you
name the macro Auto_Open, then it'll run when the workbook opens.

(But your pc will have to be on <vbg> for that to work!)
 

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

Sort Multi Time Fields 14
Run a Macro via a Scheduled Time 1
Email Excel Workbook Automatically Daily 3
What formula can i use to add time? 6
date & time question 7
Vista always wakes up 6 hours after sleep 3
Command Line to Open/Close an Excel Files , macro print it in a designated Folder 1
Find Data 2

Back
Top