Running a Macro automatically

Is there anyway of running a Macro in a spreadsheet without having to open
the spreadsheet i.e i want to run a macro on a spreadsheet overnight
automatically to update it before the users come in to use it.



Thanks

David