Running a macro at a certain time
 

Depends on what your schedule is. Excel supports an "ontime" function that can
run every xx minutes/hours/days, but excel has to be open for it to keep track.

See Chip Pearson's page for more info:
http://www.cpearson.com/excel/ontime.htm

And some versions of windows have a scheduler built into them. If you use this,
just name your macro Auto_open (in a general module) or under ThisWorkbook
(workbook_open).

There are shareware versions of schedulers available, too: www.shareware.com

tom_mugg wrote:

Not being a programmer, I am having a tough time getting a macro to run
at a certain time. The macro itself is quite simple, a set of numbers
that my spreadsheet is getting from DDE links... anyway, the macro
takes my data at the end of the day, and moves it down, therefore I can
keep a history. Rather than leave it to the night shift to open the
workbook and run the macro, I want the macro to run itself at a certain
time... I realize the workbook has to be open, no problem with that.

Thanks for the

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

--

Dave Peterson