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!)
 
Back
Top