D Davo1 Aug 20, 2009 #1 I have a macro that I want to run each day at a certain time. How can I do that in excel?
J jlclyde Aug 20, 2009 #2 I have a macro that I want to run each day at a certain time. How can I do that in excel? Click to expand... Application.Ontime http://www.cpearson.com/excel/OnTime.aspx http://www.ozgrid.com/Excel/run-macro-on-time.htm Here are 2 great websites that explain it very well. Jay
I have a macro that I want to run each day at a certain time. How can I do that in excel? Click to expand... Application.Ontime http://www.cpearson.com/excel/OnTime.aspx http://www.ozgrid.com/Excel/run-macro-on-time.htm Here are 2 great websites that explain it very well. Jay
G Gord Dibben Aug 20, 2009 #3 Will Excel be running at all times? Will the workbook with the macros be open at all times? A macro can be run at a certain time using the OnTime method but Excel and the workbook must be open. Alternative.................. Task Scheduler to start Excel at a given time with the workbook to open and Workbook_Open code to do the macro work is one method. You would not have to use OnTime method. Gord Dibben MS Excel MVP
Will Excel be running at all times? Will the workbook with the macros be open at all times? A macro can be run at a certain time using the OnTime method but Excel and the workbook must be open. Alternative.................. Task Scheduler to start Excel at a given time with the workbook to open and Workbook_Open code to do the macro work is one method. You would not have to use OnTime method. Gord Dibben MS Excel MVP
