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?
How do I specify this in the code?
D
Dave Peterson
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 Aut
pen, then it'll run when the workbook opens.
(But your pc will have to be on <vbg> for that to work!)
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 Aut
pen, then it'll run when the workbook opens.(But your pc will have to be on <vbg> for that to work!)