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

Robin Hammond
www.enhanceddatasystems.com

"arno" wrote in message
...
Hi bris,

to build a macro that refresh the data at e.g 12 p.m. every day.

one way is to enter your code to refresh data in the auto_open makro/event
of a workbook. start excel and the workbook with a "scheduled task" of
windows.

regards

arno