Hi Arno

Thanks for your answer. I face a new problem.When using this scheduled task,
this opens the excel file, but stops when excel says "contain marco.
Is there a way of disable this popup message?

Br,
Brian
"arno" wrote in message
...
Hi Robin,

the problem that i have with this sort of stuff is that it is absolutely
not
sure what's going on. has user x the file open, did he start the macro,
did
he close excel after starting, is he on holiday/ill/on tour etc. etc. etc.

this is why i'd recommend running a scheduled tasks, the PC/Server has to
be
turned on and that's it.

arno

Alternative, if Excel is running, you can use Auto_Open in say
Personal.xls
and the Application.OnTime method to launch your update code.