Run macro on certain day and time
 

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?

Run macro on certain day and time
 

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"


--
Regards,
Tom Ogilvy

"Kelly" wrote in message
...
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?