J
Jean
Does anybody know how to make an Excel macro/VBA procedure
execute automatically at pre-set time (for instance, at
mid night)?
execute automatically at pre-set time (for instance, at
mid night)?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
Chip Pearson
Jean,
You can use the OnTime method of the Application object to do
this. See www.cpearson.com/excel/ontime.htm for more details.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
You can use the OnTime method of the Application object to do
this. See www.cpearson.com/excel/ontime.htm for more details.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
G
Guest
Chip:
Thank you so much for your promt resonse and the simple
and solution, which is clear and easy to understand. I
will try it after lunch. Regards,
Jean
Thank you so much for your promt resonse and the simple
and solution, which is clear and easy to understand. I
will try it after lunch. Regards,
Jean
K
Keith R
What are the pros and cons of using Ontime vs the windows scheduler with the
code called in the workbook_open event - is there a preference? We want to
schedule different macros to run on different days (nights) instead of
hogging CPUs during the day...
code called in the workbook_open event - is there a preference? We want to
schedule different macros to run on different days (nights) instead of
hogging CPUs during the day...
G
Gord Dibben
Jean
Another tack if you don't have Excel running at all times.
Put the macro in the Workbook_Open code and use Task Scheduler to start Excel
and your file at midnight.
Add code to save the file then shutdown Excel(Application.Quit)
Gord Dibben Excel MVP
Another tack if you don't have Excel running at all times.
Put the macro in the Workbook_Open code and use Task Scheduler to start Excel
and your file at midnight.
Add code to save the file then shutdown Excel(Application.Quit)
Gord Dibben Excel MVP
C
Chip Pearson
Keith,
The only real difference is that OnTime requires that Excel be
running at the specified time. Using Windows scheduler does not
require that Excel be open.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
The only real difference is that OnTime requires that Excel be
running at the specified time. Using Windows scheduler does not
require that Excel be open.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
G
Guest
Gord:
Thanks for your response. Doing the same thing without
openning Excel workbook definitely is a good solution.
However, I have no idea how to use Task Scheduler, and
even don't know what's the Task Scheduler. Could you give
me a little detailed explanation?
Jean
Thanks for your response. Doing the same thing without
openning Excel workbook definitely is a good solution.
However, I have no idea how to use Task Scheduler, and
even don't know what's the Task Scheduler. Could you give
me a little detailed explanation?
Jean
J
Jean
Chip:
I have visited your Web pages and tried your code. The
StartTimer() works very well, and I like it so much. I
also like your Web pages and will come back more often.
Again, thanks for your help.
Jean
I have visited your Web pages and tried your code. The
StartTimer() works very well, and I like it so much. I
also like your Web pages and will come back more often.
Again, thanks for your help.
Jean