Automatically run a macro at a certain time

[Guest]

Is there a way to automatically run a macro at a certain time, i.e. at the
same time daily Tuesday through Saturday? Thanks!

 

[Bob Phillips]

See the OnTime method http://www.cpearson.com/excel/ontime.htm

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Norman Jones]

Hi Harris,

See Chip Pearson at:

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

 

[Jeff Standen]

Personally, I would use Windows Task Scheduler to open the file, have the
macro run automatically on open and then close Excel afterwards (assuming
there are no other open files).

Jeff

 

[Guest]

Thanks, I'll give it a try.
--
-Harris

See the OnTime method http://www.cpearson.com/excel/ontime.htm

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Don Guillett]

Look in help for ONTIME