Running MAcro at a set time
Posted by H Davis on August 21, 2000 3:12 PM
Is it possible to have a macro start itself
at a designated time?
Posted by Aaron on August 23, 0100 6:13 AM
Look at the "Application.OnTime" method in VBA help.
Aaron
Posted by Michael Liu on August 21, 0100 8:10 PM
Two methods.
1) Set the macro to be called with Auto_Open
Schedule a task to launch that Excel file
at a specific time.
2) Use the Application.Wait function.
