Hi,

I assume the workbook is open.

Application.OnTime TimeValue("14:00:00"), "RunOnTime"
'Do things

Put this as the first line of your macro. Change the name "RunOnTime" to the
name of your macro. Run it and will run again every day at 2PM

Mike


"Yan" wrote:

Hello,

I need to run an Excel (2003) macro as a service. Every day at 2 pm to copy
data from one worksheet to another.

I alredy have written a macro but how do I set it to run everyday at 2 PM ?

Thanks

Yan