Run macro on certain day and time

  • Thread starter Thread starter Kelly
  • Start date Start date
K

Kelly

I have an Excel worksheet that I have written a macro
that goes out and pulls in certain information from a
database. The problem is that if anyone is in the
database at the time, it comes back with an error. What
I would like to do is set it up to run in the middle of
the night on the 1st day of the month. How do I go about
it?
 
Trigger the macro in the workbook_open event of the workbook.

then use the windows scheduler to start excel and open the workbook at the
appropriate date and time.

command line would be something like:
excel.exe "c:\my documents\myfile.xls"
 
Back
Top